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

[Mauro Lorenzutti]

Hi James,

try to change the marker from ###Insert_Acct### to 
###WFQBE_Insert_Acct###, than remember to fix the biniding in the search 
query record. This should work.

Regards,
-- 

Mauro Lorenzutti

CTO / Software Architect
mauro.lorenzutti at webformat.com
Tel.   +39-0427-926.389

WEBFORMAT srl -- www.webformat.com
Via S. Francesco d'Assisi, 6 -- 20122 MILANO
Corte Europa, 12 - 33097 SPILIMBERGO (PN)

*** TYPO3 Certified Integrator ***




Il 28/10/2012 21:48, James Hagist ha scritto:
> 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
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english