WebDNA is a scripting and database system designed to easily build web applications.
WebDNA and BioType
BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5
Download WebDNA
Download WebDNA freeware, try it and register later if you want.
WebDNA resources
The list of all WebDNA instructions.
Menu
What is WebDNA
WebDNA is a scripting and database system designed to easily build web applications.
WebDNA and BioType
BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5
Download WebDNA
Download WebDNA freeware, try it and register later if you want.
WebDNA resources
The list of all WebDNA instructions.
What is WebDNA
WebDNA is a scripting and database system designed to easily build web applications.
WebDNA and BioType
BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5
Download WebDNA
Download WebDNA freeware, try it and register later if you want.
WebDNA resources
The list of all WebDNA instructions.
What is WebDNA
WebDNA is a scripting and database system designed to easily build web applications.
WebDNA and BioType
BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5
Download WebDNA
Download WebDNA freeware, try it and register later if you want.
WebDNA resources
The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
Menu
HOME
DOWNLOADS
LEARN
EDUCATION
NEWS
COMMUNITY
STORE
SUPPORT
CONTACT
[WebDNA] SQL Search
This WebDNA talk-list message is from
2010
It keeps the original formatting.
numero = 104685
interpreted = N
texte = Seem to be having trouble searching a MySQL db, and am sure its the way I wrote the line. I don't have any trouble reading, or writing to it, so it has to be something I'm missing in the search. From Form: ------------------------------
Search
---------------------------------- Results page ---------------------------------- [SQLConnect dbType=MySQL&host=localhost&database=mydatabase&uid=ineeda&pwd=drink&conn_var=conn1] [/SQLConnect] [SQLExecute conn_ref=conn1&result_var=rs1] SELECT dealer, prod_desc FROM prod WHERE MATCH(dealer, prod_desc) AGAINST ('searchterm'); [/SQLExecute] [SQLResult result_ref=rs1] [numFound] records found [FoundItems] [/FoundItems]
Dealer
Product Description
[dealer]
[prod_desc]
[/SQLResult] ------------------------------- Is what I'm drinking not enough, or to much... hic.... any help would be appreciated. Rob
Associated Messages, from the most recent to the oldest:
Seem to be having trouble searching a MySQL db, and am sure its the way I wrote the line. I don't have any trouble reading, or writing to it, so it has to be something I'm missing in the search. From Form: ------------------------------
Search
---------------------------------- Results page ---------------------------------- [SQLConnect dbType=MySQL&host=localhost&database=mydatabase&uid=ineeda&pwd=drink&conn_var=conn1] [/SQLConnect] [SQLExecute conn_ref=conn1&result_var=rs1] SELECT dealer, prod_desc FROM prod WHERE MATCH(dealer, prod_desc) AGAINST ('searchterm'); [/SQLExecute] [SQLResult result_ref=rs1] [numFound] records found [founditems] [/FoundItems]
Dealer
Product Description
[dealer]
[prod_desc]
[/SQLResult] ------------------------------- Is what I'm drinking not enough, or to much... hic.... any help would be appreciated. Rob
Rob
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...