Re: Search breaks based on search string

[g0n]

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?

[Kiko]

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

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

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!