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
Dealer
Product Description
[FoundItems]
[dealer]
[prod_desc]
[/FoundItems]
[/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
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...