Is the ID-field a text field? If it's a number field then you should omit the single quotes in the sql:
sql = sql & "INSERT INTO MyTable (id, name, age)"
sql = sql & "VALUES (" & ID & ",'" & Name & "', '"& Age &"');"
Take a look at the...
I think that it's possible if you use a session variable.
When you know the title then define the session variable:
<% Session("Title")="theTitle" %> or use a variable
<% Session("Title")=theVariable %>
and in the asp pages...
Try this:
CompanyName = Replace(CompanyName,"'","?")
before you set up the SQL
and in your SQL
... where CompanyName like '" & CompanyName & "' .....
Olav
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.