Tags:
create new tag
view all tags

SID-00335: Two Database queries on the same line not permitted ?

Status: Unanswered 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:

loginid1

Instead of:

loginid1 emailid1

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

      Change status to:
ALERT! 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.
SupportForm
Status Unanswered
Title Two Database queries on the same line not permitted ?
SupportCategory CategoryPlugins
TWiki version 4.1.2
Server OS Windows 2003
Web server Apache 1.3.39
Perl version 5.008008 (cygwin)
Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | Raw edit | More topic actions
Topic revision: r2 - 2009-07-05 - PeterThoeny
 
  • Learn about TWiki  
  • Download TWiki
This site is powered by the TWiki collaboration platform Powered by Perl Hosted by OICcam.com Ideas, requests, problems regarding TWiki? Send feedback. Ask community in the support forum.
Copyright © 1999-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.