SID-00335: Two Database queries on the same line not permitted ?
Status: |
Unanswered |
TWiki version: |
4.1.2 |
Perl version: |
5.008008 (cygwin) |
Category: |
CategoryPlugins |
Server OS: |
Windows 2003 |
Last update: |
14 years ago |
The database plugin query:
%DATABASE_SQL{description="descr1" sql="SELECT * FROM table1 WHERE PersonnelNo='1234' " " format="$PersonnelNo" separator="$nop" }%
Gives the output:
loginid1
The database plugin query:
%DATABASE_SQL{description="descr2" sql="SELECT * FROM table2 WHERE PersonnelNo='1234' " " format="$EmailId" separator="$nop" }%
Gives the output:
emailid1
But if I put both queries on the same line like:
%DATABASE_SQL{description="descr1" sql="SELECT * FROM table1 WHERE PersonnelNo='1234' " " format="$PersonnelNo" separator="$nop" }% %DATABASE_SQL{description="descr2" sql="SELECT * FROM table2 WHERE PersonnelNo='1234' " " format="$EmailId" separator="$nop" }%
It executes just the first one and gives the output:
loginid1
instead of:
loginid1 emailid1
in fact, I want it to be in a table like:
| %DATABASE_SQL{description="descr1" sql="SELECT * FROM table1 WHERE PersonnelNo='1234' " " format="$PersonnelNo" separator="$nop" }% | %DATABASE_SQL{description="descr2" sql="SELECT * FROM table2 WHERE PersonnelNo='1234' " " format="$EmailId" separator="$nop" }% |
but the result is the same. it executes the first query and gives the result:
Instead of:
Is there a solution for this ?.
--
ChengappaCB - 2009-05-26
Discussion and Answer
Closing this question after more than 30 days of inactivity. Feel free to reopen if needed. Consider engaging one of the
TWiki consultants if you need timely help. We invite you to
get involved with the community, it is more likely you get community support if you support the open source project!
--
PeterThoeny - 2009-07-05
If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.