case number with spaces.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29611
interpreted = N
texte = I have a clients FMP database that I am porting over to webcat and here is what I am tring to do. The client wants one part of the site to display a range of records based on the case number field.the format of the case number is:'XX A XXX' where X=Number and A=AlphaCharacterI want to search on a range like rnCaseNumberdata=00 F 701+00 F 714here is the code I have fighting with:[search db=../data/database.db&CaseNumberType=text &rnCaseNumberdata=00 F 700+00 F 714& FileDatesort=1&CaseNumbersort=2]I tried a few different versions:[search db=../data/database c.db&CaseNumberType=text &CaseNumberword=+& rnCaseNumberdata=00 F 700+00 F 714& FileDatesort=1&CaseNumbersort=2]I basically want WebCat to look at the whole Case Number as one whole string to match (that's not a problem) but I want to search the Range of Serial Number.Any Ideas or should I just add a few more fields in FMP that 'dismantle' the serial number?I figured that WebCat should be able to handle this, hey it's all 1's and 0's anyway.------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
I have a clients FMP database that I am porting over to webcat and here is what I am tring to do. The client wants one part of the site to display a range of records based on the case number field.the format of the case number is:'XX A XXX' where X=Number and A=AlphaCharacterI want to search on a range like rnCaseNumberdata=00 F 701+00 F 714here is the code I have fighting with:[search db=../data/database.db&CaseNumberType=text &rnCaseNumberdata=00 F 700+00 F 714& FileDatesort=1&CaseNumbersort=2]I tried a few different versions:[search db=../data/database c.db&CaseNumberType=text &CaseNumberword=+& rnCaseNumberdata=00 F 700+00 F 714& FileDatesort=1&CaseNumbersort=2]I basically want WebCat to look at the whole Case Number as one whole string to match (that's not a problem) but I want to search the Range of Serial Number.Any Ideas or should I just add a few more fields in FMP that 'dismantle' the serial number?I figured that WebCat should be able to handle this, hey it's all 1's and 0's anyway.------------------------------------------------------------- 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
Eric Ridgley
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:
[Webcat 2]Next (1997)
Don't tick me off :) [elaspedtime] (1997)
Multiple 'Users.db' files not possible (1997)
webcat 2.1 new cart fields - please explain more (1998)
URGENT: WebCatalog 2.0 (1998)
PROBLEM (1997)
Testing (2003)
Before I Can Begin . . . (1998)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
GrandTotal not right (1997)
hyperlinking unique input strings on the fly when displayingin HTML (2000)
What am I missing (1997)
Help Encrypt/Decrypt eMail (2003)
Multiple prices (1997)
Generating unique SKU from [cart] (1997)
credit card question (simple) (2001)
Is there a way......... (2000)
Stumpted Again (1997)
Fw: Linux w/ apache (2000)
ShowNext (1997)