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:

using showpage and showcart commands (1996) Multiple Replaces? (1997) DreamWeaver Extensions (2000) Cart date/time (2006) really wierd browser truncating (1997) mass mailing (1998) OT - How to pay commissions to non US affiliates? (2000) RE: Nesting [ListFiles] (1998) Flash integration (2002) WebCat2b12 CGI Mac -- Problems propagating the cart through (1997) Emailer error 571 (1998) Protect vs Authenicate (1997) Am I going senile? (Price recalc based on quantity) (1997) [math] show=F exists? (1997) Re:2nd WebCatalog2 Feature Request (1996) Web Catalog 2 demo (1997) Is someone's computer clock set wrong? (2000) WebCatalog NT beta 18 problem (1997) Pass a form (2003) [BoldWords] WebCat.acgib15Mac (1997)