This topic is locked

Custom Page

12/1/2010 1:56:25 PM
ASPRunnerPro General questions
A
andie.caron author

Hi all, long time. I have a project that I'd like to create a page for that will display a table (let's say imports). Then on this page, I'd like to have a drop list (selection list) that will allow a user to attach the imported records to an account that is selected via the selection list.
We've tried all kinds of ideas but are having issues with trying to place a list box on the screen that will populate from a table 9accounts). So far we've done this in Dreamweaver and it works well, but we'd like to stick with the same format, layout and theme that our aspr project uses (also the security intigration).
I hope this is clear, if not please let me know as we'd like to get this working.
thanks all.
Oh: aspr 6.1, windows 2003 server (everything works fine here).

J
Jane 12/3/2010

Hi,
I'm not sure that I fully understand your question.

Could you clarify what does 'imported records' mean?

A
andie.caron author 12/3/2010



Hi,
I'm not sure that I fully understand your question.

Could you clarify what does 'imported records' mean?


I'm sorry I was trying not to clutter the post. Scenario goes like this, a user clicks on a link on a page to import records into a table (called SEQNO-ImportedData). This is a custom script that we use because we ran into issues with the built in one. Also, this allows us to map input fields (from a CSV, TXT or XLS file) to the fields in our actual table - called Imports.
Then the data is imported into "SEQNO-ImportedData". So our script then moves the data form the SEQNO-ImportedData table into the acutal table "Imports".and we insert the current user id (and a few other needed pieces into the actual table "Imports").
So it goes like this: Click on import --> run our script to allow user to select import file --> map fields to our actual table --> cleanup imported data table (created on the fly using sql create table).
What we now need to be able to do is to use a drop down list of three possibilities from another table ("AgentActiveRequests") that says these new Imported records belong to one of the three from the drop list. The purpose here is to send an email to the account owner that we have imported new real estate leads and he/she can then view. The messages would be send using AgentActiveRequests and it's children that were imported.
Does this help???

Sergey Kornilov admin 12/5/2010

It looks like you need to create a totally new page from scratch. ASPRunnerPro doesn't provide such functionality.

A
andie.caron author 12/8/2010



It looks like you need to create a totally new page from scratch. ASPRunnerPro doesn't provide such functionality.


Thanks, I was sorta heading in that direction. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=55014&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />