SQL Madness

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 62603
interpreted = N
texte = Windows EXE version 6.0Have an ODBC setup for this to MSSQL which up until now has workedwonderfully (well at least I thought so).Here is the dilemma. While trying to do a 'contains' search on any field(varchar or integer) the results are erratic when searching on anything thatis number (integer) related.For example:[SQL dsn=SOMEDSN&username=SOMEUSERNAME&password=SOMEPASS&statement=SELECT * from tickets wheredescription LIKE '%[descriptionvar]%' ORDER BY priority][founditems][title]
[/founditems][/sql]Works great until you search on something like 54.So a record that has the phrase:"We ordered item number 5437. This item should be delivered promptly"In the description field (which is a varchar field)54 Returns the proper result. However, change that search string to 543 andnothing. 5437, nothing.This is a simplistic example but I have tested this now on varchar fieldsand integer fields. It appears that anything over 1 or 2 chars in yoursearch string (if they are numbers) sends back 0 results. If you search on 1number I am getting results for records that do not even have the number inuse. :_(Of course running these simple searches through query analyzer works like acharm so I am 100% certain this is a result of WebDNA communicating withMSSQL. Like I said, the interaction between the 2 has been flawless and VERYproductive -- until this.Has ANYONE seen erratic results when dealing with LIKE searches and if sodoes anyone have any advice. I am about ready to go postal. This started asa fairly complicated search and after many hours of trying to 'fix it'reducing it to the most simple of searches showed that there is no fixingerratic results on a single variable search.Help!Alex-- Alex J McCombie Adventure Skies Interactive (ASI)Owner Box 124888/892.6379 MartVille, NY 13111Alex@Adventureskies.comInterface Designer WebDNA Programmer Database Designer-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: SQL Madness ( Alex McCombie 2005) Re: SQL Madness ( "Scott Anderson" 2005) Re: SQL Madness ( Alex McCombie 2005) Re: SQL Madness ( Jesse Proudman 2005) Re: SQL Madness ( "Scott Anderson" 2005) SQL Madness ( Alex McCombie 2005) SQL Madness ( Alex McCombie 2005)

Windows EXE version 6.0Have an ODBC setup for this to MSSQL which up until now has workedwonderfully (well at least I thought so).Here is the dilemma. While trying to do a 'contains' search on any field(varchar or integer) the results are erratic when searching on anything thatis number (integer) related.For example:[SQL dsn=SOMEDSN&username=SOMEUSERNAME&password=SOMEPASS&statement=SELECT * from tickets wheredescription LIKE '%[descriptionvar]%' ORDER BY priority][founditems][title]
[/founditems][/sql]Works great until you search on something like 54.So a record that has the phrase:"We ordered item number 5437. This item should be delivered promptly"In the description field (which is a varchar field)54 Returns the proper result. However, change that search string to 543 andnothing. 5437, nothing.This is a simplistic example but I have tested this now on varchar fieldsand integer fields. It appears that anything over 1 or 2 chars in yoursearch string (if they are numbers) sends back 0 results. If you search on 1number I am getting results for records that do not even have the number inuse. :_(Of course running these simple searches through query analyzer works like acharm so I am 100% certain this is a result of WebDNA communicating withMSSQL. Like I said, the interaction between the 2 has been flawless and VERYproductive -- until this.Has ANYONE seen erratic results when dealing with LIKE searches and if sodoes anyone have any advice. I am about ready to go postal. This started asa fairly complicated search and after many hours of trying to 'fix it'reducing it to the most simple of searches showed that there is no fixingerratic results on a single variable search.Help!Alex-- Alex J McCombie Adventure Skies Interactive (ASI)Owner Box 124888/892.6379 MartVille, NY 13111Alex@Adventureskies.comInterface Designer WebDNA Programmer Database Designer-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Alex McCombie

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

combining strings (1997) Incrementing a number (1998) [OT] 'Email this story to a friend' (2003) 5.0 Pricing (2003) Emailer setup (1997) WebCat Admin access w/ClearlyHome p.i. (1997) Expire Cookie in 8 Hours (2004) WebCat2 beta 11 - new prefs ... (1997) calculating tax rates, mail order solutions and version 2 (1997) Authenticate (1998) I'm having trouble using [url][interpret][math] together in lookup (1997) emailer settings and control questions (1997) [WebDNA] Calculate Cube root (2012) WebCatalog security on NT (2000) [OT] Bad Hard Drive? (2003) [WebDNA] [middle] (2015) emailer w/F2 (1997) Multiple prices (1997) URL problem (2007) Conditional searching & displaying (1997)