Categories > TinyButStrong general >

tbs does some strange thing with queries??

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: RwD
Date: 2004-03-11
Time: 21:21

tbs does some strange thing with queries??

I use this php code
$tbs->MergeBlock('pic',$DB->Link_ID,"SELECT * FROM picture WHERE ((picture_f_performance_id='%p1%') AND (picture_filename NOT LIKE 'x%'))") ;

and the query (with p1 replaced ofcourse) works perfectly when I try through phpmyadmin. It excludes all pictures with a name starting with an x

However, when I use the above code, it shows all pictures that meet the picture_f_performance_id requirement and including the ones starting with an x !!

Why does that happen, and how to stop it??
By: RwD
Date: 2004-03-11
Time: 22:50

Re: tbs does some strange thing with queries??

Random error :S

I restarted the sql service and everything worked ok again :S
I hope this was some sort of strange chaching error, allthough I don't think MySQL does that...

This is weird as phpMyAdmin as well as tbs use the same server. But I wouldn't give this post much thought if I were you :D

Sorry, tbs doesn't seem to be in error