Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Forecaster71
-
Replacing symbols in SQLQuery
You can check the page in question here: http://darkestdarkness.somee.com/index.htm I'm using ASP pages with Javascript and SQL- Forecaster71
- Post #5
- Forum: ANSI_SQL
-
Replacing symbols in SQLQuery
I could do that... but I want it to do it automatically so my users don't have to think about it.- Forecaster71
- Post #3
- Forum: ANSI_SQL
-
Replacing symbols in SQLQuery
If a string that is going from a text area in a database contains ' the SQLquery is interrupted. To avoid this I have to replace this ' with another symbol that does not affect the SQLquery. How do I accomplish this?- Forecaster71
- Thread
- Replies: 7
- Forum: ANSI_SQL
-
-
missing semicolon!
What should I do if I where to use UPDATE instead? I haven't used that mutch...- Forecaster71
- Post #5
- Forum: ANSI_SQL
-
missing semicolon!
The SQL query contains: QLQuery = "INSERT INTO users(userAbout) VALUES ('"&info&"') WHERE userID = "&Request.Cookies("Database")("userID")&- Forecaster71
- Post #3
- Forum: ANSI_SQL
-
missing semicolon!
I get an error that I cannot solve. As far as I know it should not be there this is the row: Set rsUser = objConnection.Execute(SQLQuery) should there be a semicolon and if so where?- Forecaster71
- Thread
- Replies: 6
- Forum: ANSI_SQL
