Re: Search bug. Help
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43509
interpreted = N
texte = Andrew Simpson wrote: > Error - line 14: you have specified an invallid data type, data type does > not match record in database or casting not required for this search type. > Click Here for help on data types.WebCat is not a strongly-typed language, so your programmer hand-holding is not possible. A given column of a table can contain text or numbers or dates and can be searched/sorted as text or numbers or dates at the whim of the programmer. In fact, unless you tell WebCat otherwise by using FIELDtype=???, every single field in every database is text and is sorted by ASCII text rules.However, this means that the programmer must know what they are doing. If you assert that a column contains numbers (FIELDtype=num) WebCat will change the way it deals with that field for the duration of that template. Hence if the field contains something that is not a number, you are going to have problems.This is a classic DON'T DO THAT! sort of behavior. If you want to have a strongly typed API, use ASP or C or VB.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Andrew Simpson wrote: > Error - line 14: you have specified an invallid data type, data type does > not match record in database or casting not required for this search type. > Click Here for help on data types.WebCat is not a strongly-typed language, so your programmer hand-holding is not possible. A given column of a table can contain text or numbers or dates and can be searched/sorted as text or numbers or dates at the whim of the programmer. In fact, unless you tell WebCat otherwise by using FIELDtype=???, every single field in every database is text and is sorted by ASCII text rules.However, this means that the programmer must know what they are doing. If you assert that a column contains numbers (FIELDtype=num) WebCat will change the way it deals with that field for the duration of that template. Hence if the field contains something that is not a number, you are going to have problems.This is a classic DON'T DO THAT! sort of behavior. If you want to have a strongly typed API, use ASP or C or VB.John-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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://search.smithmicro.com/
John Peacock
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:
WebCatalog Hosting (1996)
Generating Report Totals (1997)
AutoCommit Preference? (1998)
Location of Browser Info.txt file (1997)
Date search - yes or no (1997)
[WebDNA] To Commitdatabase or Not to Commitdatabase (2012)
New Guestbook Source (1997)
Selecting sort fields (2000)
Mem per threads (1998)
Listfiles (1998)
[ShowIf] if the varieable exists (1998)
THANKS (1997)
Emailer [cart] file names (1997)
mail on NT (1998)
RE: Can a database get stomped by simultaneous access? (1997)
more info on [setlineitems] (1997)
Showing once on a founditems (1997)
RAM variables (1997)
Date Time Oddness (1999)
Serving images from databases (1998)