[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