On Tue, 11 Mar 2008 16:12:06 -0700, Manuel <Manuel@discussions.microsoft.com> wrote: You're doubling up on the "WHERE" keyword. To debug issues like this, set a breakpoint and get the value of your sql statement. Then paste it into a new query (in SQL view). Switch to Design view and the parser will bark at you. -Tom. I have a table which stores SQL statements as strings. I'm trying
Hi, I was wondering if someone could help me with this problem. I have a set of if commands that are designed to take the input from a text field and search three different fields for the value that's been typed in. If the text is present in ANY of the three fields I want it to be returned in the XML list. if (searchXMLl.(serviceName.toLowerCase().search(freeTextAllSearch.text.toLowerCase
Jason Carlton wrote: Yep, I'm still playing with my message board! The DB contains 2 tables: a smaller table for the Subjects, and a larger table with all of the Posts. You may recall that this was originally in Perl, but I'm moving a portion to PHP because it seems to run queries a little faster. The portion that I'm moving (for now) is the part that lists the subjects, before
On Nov 27, 1:04 am, Jason Carlton <jwcarl...@gmail.com> wrote: Yep, I'm still playing with my message board! The DB contains 2 tables: a smaller table for the Subjects, and a larger table with all of the Posts. You may recall that this was originally in Perl, but I'm moving a portion to PHP because it seems to run queries a little faster. The portion that I'm moving (for now) is
Yep, I'm still playing with my message board! The DB contains 2 tables: a smaller table for the Subjects, and a larger table with all of the Posts. You may recall that this was originally in Perl, but I'm moving a portion to PHP because it seems to run queries a little faster. The portion that I'm moving (for now) is the part that lists the subjects, before you click to read the thread.