[TYPO3-english] EXT: wfqbe DB Integration -- Seach Template Error

James Hagist james.hagist at gmail.com
Sun Oct 28 21:48:10 CET 2012


I have a query

SELECT account_table.Account, account_table.Accounting_Group_Full_Desc,
account_table.Responsibility_Code_Full_Desc, account_table.Primary_Name,
account_table.Name_2, account_table.Name_3, account_table.Tax_ID_Number,
account_table.Birthday, account_table.Home_Phone,
account_table.Business_Phone, account_table.Current_Balance,
account_table.Prev_MTD_Amount_Min_Balance, account_table.Number_Of_Credits,
account_table.Number_Of_Debits, account_table.Account_Type,
account_table.Product_Name, account_table.Product_Number,
account_table.New_Product_Name, account_table.New_Product_Number,
account_table.Customer_Letter, account_table.FAQ FROM account_table WHERE
account_table.Account = ###Insert_Acct###

When I run the seach template I get the following error

Query failed (uid=1)
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 '' at line 1

The detail template works if I hard code the account number to be an exact
number (1234)

The error occurs with the search.

Thanks in advance,
James


More information about the TYPO3-english mailing list