Convert your tables to quality asp code.

access2asp

step 1


    create a folder called contactDemo ( or a name of your choice )

    *this folder should be a folder enabled by IIS or personal web server
    for more information on setting up personal web server or IIS then click here or here.

    select the folder that you lovingly created above...



    select the database you want to convert... (for the purposes of our tutorial we are going to use a simple contact database which is included in the support material at the end of this tutorial.)


    select how many records per page you want to see on your list screens...

    Choose wether you want to include the function to make urls live on memo fields. (full version only.)
    (click here for a fuller explanation of this function)

    Choose your username and password (full version only)

    Choose which tables you wish to convert (full version only - free version converts only 1 table )

    click 'generate asp'





step 2


    open up your browser and browse to http://localhost/contactDemo/

    you should see a menu as below.



    If you dont see the menu then make sure pws\iis is started and the folder you created the asp files in has permission to run scripts!

    click on contacts you should see this...


    dont panic!

    what you can see is the id numbers of your contacts(try clicking on one!)

    changing just one line of code will make ot look like this


    So lets change that line!
    Open up your html editor, or if you dont have one then open up notepad and browse to your folder and open up the file contactslist.asp

    locate the line that you can see below
    (line 93 towards the bottom of the page!)

    <a href=contactsdetail.asp?id=<%=rs("contactId")%>&pageno=<%=pageno%>><%=rs("contactId")%></a>

    change the second instance of rs("contactid") to rs("contactname")

    <a href=contactsdetail.asp?id=<%=rs("contactId")%>&pageno=<%=pageno%>><%=rs("contactName")%></a>

     

    save your file and refresh your browser.

    now go to http://localhost/contactDemo/admin/

    click on the contacts link

    dont panic!

    know whats coming next?

    thats it - browse to your admin folder(located within your contactDemo folder ) and open up the file contactListAdmin.asp

    change the field contactid to contactname ( line 95 towards the bottom of the page ) in exactly the same place as in the previous step.

    Thats it !

    Try adding some records.

    See the 'front end' change to reflect your changes

    what you have now is the backbone of a dynamic site which would have many hours to hand code.*

    the process is this simple for any other table. ( if you had another table called companies then you would simply change the same line in companiesList.asp and companiesListAdmin.asp )

    next step - change fonts,colors etc

    next step - buy the full version! - and convert as many tables as you like !

    HAPPY CODING!


    *****************************************************************************
    explanation of the function make urls live on memo fields
    example:

    ArticleDescription

    say you enter the above text in the admin section for a news database.
    when this appears on the 'front end' it will appear like this ..


    I found a great tool
    you can check it out at http://www.access2asp.com - pretty cool!

    the link will be 'live' or clickable due to the function makeUrlsLive.


 

email access2asp