2. ASPRunnerPro General questions
  3. A link directly to ..._edit.asp page
This topic is locked

A link directly to ..._edit.asp page

 		8/2/2004 10:19:48
ASPRunnerPro General questions
author

Hi,
I want to make a link from my site directly to the ..._edit.asp page, where new customers could add their information.

When I write simple link it doesn't work.
Error number -2147217900

Error description [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[ID]='.

SQL query select [ID], [Login], ....... from [online] where [ID]=
I see, that problem is in the ID value, but I don't know how to solve this problem <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=744&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Aleksej
500147 8/3/2004

Anybody knows how to solve this problem?
swat 8/3/2004

Aleksej-
If you want the user to enter new data using new link, first open up your ...._list.asp file and clink Add New to open a blank form ... now just copy this page's code and save as ......_new.asp (make sure u have the file extension as asp also you need to save this file under same directory with ...._list.asp or ..._edit.asp files)....after you saved this new page named as ...._new.asp you can now use this link any where you want.
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=2292&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />
Sergey Kornilov admin 8/4/2004

Aleksej,
you can try ASPRunnerPro 3.1 beta that builds separate ADD page. In this version you can point user to the ..._add.asp page directly.
http://www.asprunner.com/files/asprunnerpro31a.exe
swat 8/4/2004

admin-
Do you have separate page for ......._edit.asp on asprunnerpro3.1? I would like to make some changes on edit.asp page.

thx
Sergey Kornilov admin 8/5/2004

Sure, ASPRunnerPro 3.1 beta features separate pages for ADD, EDIT and VIEW that can be easily customized.
Sarjent 8/24/2004

How can I (or my company) sign up for getting a beta version to test? We had to stop using 3.0 because it wasn't 'enough' (don't know what the boss meant by enough). I liked it myself but he signs the checks hehe. Sorry to hijack this thread..
500148 8/24/2004

http://www.asprunner.com/files/asprunnerpro31a.exe
Sarjent 8/25/2004

thanks but I was looking for a more official response. Not really trusting of links posted by anonymous account if you can sympathize.
Sergey Kornilov admin 8/27/2004

Sarjent ,
feel free to download this beta and try it. Let me know if you have any problems using this beta:
http://www.asprunner.com/files/asprunnerpro31a.exe
Here is the full list of new features in this beta version:

Full list of new features in this beta:

  1. Vertical layout on the list and printer-friendly pages
  2. Totals on the list and printer-friendly pages
  3. New "View as" types:
    • US phone number
    • HTML
    • Number


  4. Separate page for Edit, Add and View (builds easy to modify ASP

    code). Explicit fields order on all pages.
  5. New set of options for "Hyperlink" type field
    • open in a new browser window
    • display URL, predefined word or another database field content


  6. Search box is optional now. It won't appear if you don't select any

    search fields.