Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Bug Reports » SQL Syntax error
Re: SQL Syntax error [message #2226 is a reply to message #2212] Thu, 16 July 2009 13:02 Go to previous messageGo to previous message
gpatti is currently offline  gpatti
Messages: 283
Registered: August 2008
Senior Member
scriptNext() is working!!

However, it seems the variable order is significant after all. I now have
$where = "$selection AND branch.crf_type_id = '$crf_type_id'";

The difference since the very first post is the order of the selection criteria variable and $selection. It fails if I put them the other way round. I had also changed a relationship so that the table qualifier is different, but I don't think that was significant. I'd accidentally had an additional 'AND' when I did the previous post so that solves the different versions of the same syntax error. Sorry about that one.

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: New Hosting Account Bug
Next Topic: Where is where
Goto Forum:
  


Current Time: Sat Nov 16 14:09:46 EST 2024

Total time taken to generate the page: 0.03556 seconds