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 PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 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 PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 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:
Cart # Starting at 1000 (2000)
locking variables? (2000)
Fun with dates (1997)
Problems searching from a FORM (1997)
Re:Virtual hosting and webcatNT (1997)
Moment of Thanks (1997)
WebCat & Backoffice Solution? (2000)
printing twice? and fix (1997)
File Upload (1997)
can you use [middle] in a search? (2001)
[WebDNA] Attack? (2015)
Buying sans cart (1997)
Price and Formula.db (2002)
shipping costs (1998)
Hiding HTML and breaking the page (1997)
# of real domains on 1 web server (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
Field name-subcategory (1997)
[WebDNA] Date weirdness (2014)
Un[url]ize (1999)