Forums :: Advanced Search

DwZone Forum
Welcome to the DwZone-it Forum

FAQ

Memberlist

Usergroups

Advanced Search

DwZone Forum Index -> Advanced Search

Moderators: Administrators, Moderators

Mark all topics read

Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.

	Search for
View Per page Messages Since

Messages 191 to 200 of 282 (Total: 122)

First | Prev | Next | Last

Subject

Author

Date

Re:No result

[email protected]

23:14 21 Feb 2007

Re:No result

[email protected]

23:15 21 Feb 2007

Re:No result

gianluigi

10:33 22 Feb 2007

Re:No result

[email protected]

15:12 22 Feb 2007

MYSQL syntax problem

[email protected]

4:21 20 Feb 2007

Re:MYSQL syntax problem

[email protected]

4:34 20 Feb 2007

I have read the previous errors and unistalled ver 2.0.1 to 2.0.2 change my slq statement to:

SELECT Ticket_no, Registration_No, Issued_Date, Issued_Time, Vehicle_Make, Vehicle_Colour, Reason, Location_Code, Issued_By, Ticket_Status, Paid_date
FROM Tickets
WHERE Location_Code = '"&strloc3&"'
ORDER BY Ticket_No DESC

I am still getting an error:
WARNING!!
Error in Advanced Search extension

-----------------------------------
SELECT Ticket_no, Registration_No, Issued_Date, Issued_Time, Vehicle_Make, Vehicle_Colour, Reason, Location_Code, Issued_By, Ticket_Status, Paid_date FROM Tickets WHERE Location_Code = '821' ORDER BY Ticket_No DESC

-----------------------------------
SELECT Ticket_no, Registration_No, Issued_Date, Issued_Time, Vehicle_Make, Vehicle_Colour, Reason, Location_Code, Issued_By, Ticket_Status, Paid_date FROM Tickets WHERE WHERE Location_Code = '821' AND (Registration_No like '%a%') ORDER BY Ticket_No DESC

-----------------------------------
[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Location_Code = '821' AND (Registration_No like '%a%') ORDER BY Ticket_N' at line 1