2. ASPRunnerPro General questions
  3. Template Cars
This topic is locked

Template Cars

 		4/24/2008 17:58:22
ASPRunnerPro General questions
E
 ebolisa author

Hi,

I'd like to use the template Cars which came with the application and instead of using the default Access DB, use MSSQL. I noticed the SQL script which came with it as well but my question is, how to make the change w/o disrupting too much the template itself?

Thank you,

Emilio

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8280&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />
Sergey Kornilov admin 4/24/2008

In ASPRunnerPro 5.2 you can select between MS Access, SQL Server and MySQL while creating a new project from the template.
E
 		ebolisa author 4/27/2008

Thank you, I went so fast I didn't see the option.
I linked the Project to MSSQL and structured the tables as follows:

tblCars having Car_ID, User_ID, Make_ID, Model_ID, SubModel_ID... and so on.

tblMakes having Make_ID, Make

tblModels having Model_ID, Model

tblSubModels having SubModel_ID, SubModel.. and so on.

The tables relation is done using the PK xxx_ID.

I'd like the user to be able to add new Makes, Models and Submodels to the tables so in the Add and Edit pages I enabled the "Allow to add new values on the fly" specifically for this reason. The Lookup wizard test works picking up the right values. In the asp pages, when adding a new submodel, the model_ID is showed instead of the Model name. How can I show the latter instead of the ID?

Thank you.

Emilio

Test site
Sergey Kornilov admin 4/28/2008

When you setup a Lookup wizard choose Model as a Display field.
E
 		ebolisa author 4/30/2008

Actually, the Make name should be displayed when adding or editing a model. In my case the make_ID is shown which it is not appropiate.

Test site
Rgs,

Emilio
Sergey Kornilov admin 4/30/2008

Emilio,
I recommend to to post your application to Demo Account and send the URL to support@xlinesoft.com.