RE: Troubles with database searching

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have stumbled apon the answer to my problem. When entering the value in the
form I must include the single quotes. This is a suprise to me as I did not
need them on when I was running the site on my XP machine.

Thanks anyways.

"Mr. Know Nothing" wrote:

> I am using FP 2002 and win server 2003 enterprise edition. I have a database
> of addresses that i want to be able to search throught via my site. I have
> made the query: "Select * from Dealers" this works but then when i use the
> query: "Select * from Dealers WHERE province = ::T1::" i get an error (error
> can be seen at www.ujr.ca/test/canadadealers.asp)
>
> The steps from when it's working to when it is not are as follows:
> 1) change the query
> 2) at the last step in the database results wizard made sure that the "Add
> search form" is checked
> 3) click finish, and then save and publish
>
> Values that should work are: NS, Nova Scotia, Ontario
> I have tried to have one of these values as default value and still get the
> same error.
>
> If anyone can help me with this it would be greatly appreciated.
.

Relevant Pages

  • Possible "bug" found in gnatcoll-sql_impl.adb
    ... I end up with more characters than I've bargained for. ... I end up with Peter in the database. ... extra single quotes added to all my string data. ...
    (comp.lang.ada)
  • Re: Syntax error (missing operator) in query expression
    ... > and how to use single quotes and double quotes in ASP? ... expression to "scrub" the search term prior to constructing the SQL ... query depending on your database environment) instead of dynamically ... constructing the SQL statement. ...
    (microsoft.public.inetserver.asp.general)
  • Re: SQL Injection
    ... Make sure you always escape single quotes and other magic characters when ... you enter data into your database. ...
    (borland.public.delphi.non-technical)
  • Re: What Did I Miss Here?
    ... Is the Use Quoted Identifiers option checked in your database property sheet ... under the Options tab? ... > In the database it is being stored as two single quotes. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Need a Strategy to store the Single Quotes in the Database
    ... >> Database where if i try to Store the String value with Single Quotes ... >> then it is throwing the error as SQL String Truncated. ...
    (microsoft.public.dotnet.languages.vb)