Re: Search breaks based on search string

That's a fairly large chunk of code. I can't see any obvious bugs, but not having your database it's tricky to debug.

I notice you print out the sql statement at the end of your HTML. At risk of stating the obvious, have you run the failing sql statements directly against the database, to see if you get the same results?

--------------------------------------------------------------

g0n, backpropagated monk

Comment on Re: Search breaks based on search string

Replies are listed 'Best First'.
Re^2: Search breaks based on search string by Kiko (Scribe) on Sep 01, 2005 at 19:48 UTC
Thanks for your reply! I print out the statement in white for debugging purposes. I ran this query against the DB and it came back fine, but in the script it hangs: `SELECT bb_id, emp_user_name, bb_activity_code, bb_model, bb_pin, bb_ph +one, bb_imei_esn_dec, bb_status, bb_region_code FROM blackberry ORDER + BY emp_user_name` [download] This script returned no values in Access, but once i removed the emp_user_name LIKE '%%' part, it ran fine: `SELECT bb_id, emp_user_name, bb_activity_code, bb_model, bb_pin, bb_ph +one, bb_imei_esn_dec, bb_status, bb_region_code FROM blackberry WHERE + emp_user_name LIKE '%%' AND bb_status='DEPLOYED' ORDER BY emp_user_n +ame` [download] I'm going to make a few modifications to see if i can fix it now that i have more to work with. Thanks for the advice!	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^2: Search breaks based on search string
by Kiko (Scribe) on Sep 01, 2005 at 19:48 UTC

SELECT bb_id, emp_user_name, bb_activity_code, bb_model, bb_pin, bb_ph
+one, bb_imei_esn_dec, bb_status, bb_region_code FROM blackberry ORDER
+ BY emp_user_name
[download]

SELECT bb_id, emp_user_name, bb_activity_code, bb_model, bb_pin, bb_ph
+one, bb_imei_esn_dec, bb_status, bb_region_code FROM blackberry WHERE
+ emp_user_name LIKE '%%' AND bb_status='DEPLOYED' ORDER BY emp_user_n
+ame
[download]

[reply]
[d/l]
[select]