Netscape SQL problem

Results 1 to 3 of 3

Thread: Netscape SQL problem

  1. #1
    Join Date
    Dec 1969
    Posts
    9

    Default Netscape SQL problem

    "400 Bad Request<BR>Due to malformed syntax, the request could not be understood by the server. The client should not repeat the<BR>request without modifications."<BR><BR>This is what I get when I´m trying to search a database with the following sql-query:<BR><BR>sql = "SELECT * FROM SystemInformation WHERE Systemname = &#039" <BR>sql = sql &"&#039" & system & "&#039"<BR><BR>The variable system I get from the following:<BR>system = request.querystring("system")<BR><BR>The only time the problem occurs though, is when the variable system has spaces in it, and only in Netscape. I can´t cut out the spaces as they are essential for the database search.<BR><BR>Somebody please help me!!<BR>

  2. #2
    Nobody Guest

    Default RE: Netscape SQL problem

    SQL = "SELECT * FROM SystemInformation WHERE Systemname = &#039" & system & "&#039"<BR><BR>Too many apostrophies.<BR><BR>Regards<BR><BR><BR>Nobody

  3. #3
    Join Date
    Dec 1969
    Posts
    9

    Default RE: Netscape SQL problem

    That´s not the problem as it works perfectly when there are no spaces in the string.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •