Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
Hello,
what's the syntax for join two tables in sqlhelper?
Fabio
Hey Fabio,
Not sure what you mean? The table joins are done via the SQL.
Rich
Sorry, perhaps I expressed myself badly.
I need to execute a reader via sql helper. But i need the data of two tables.
I used :
"select * from Table1,Table2 where Table1.id = @id and Table1.foreign = Table2.id "
but not work.
In regular XSLT, this works if you have a .NET extension set up:
<xsl:variable name="name_of_string" select="SQL:GetDataSet('Your-Database-Name', 'SELECT columns, from, both, tables, separated, by, commas FROM Table1 INNER JOIN Table2 ON Table1.id = Table2.id WHERE (set whatever conditions here) ', 'name_of_string')" />
Then call your column names in xsl:value-of statements to access the XML data. Eg, <xsl:value-of select = "columns" />
I haven't used SQL Helper, so I'm sorry if this is irrelevant. But this solution works without SQL Helper.
is working on a reply...
Write your reply to:
Upload image
Image will be uploaded when post is submitted
Join with SqlHelper
Hello,
what's the syntax for join two tables in sqlhelper?
Fabio
Hey Fabio,
Not sure what you mean? The table joins are done via the SQL.
Rich
Sorry, perhaps I expressed myself badly.
I need to execute a reader via sql helper. But i need the data of two tables.
I used :
"select * from Table1,Table2 where Table1.id = @id and Table1.foreign = Table2.id "
but not work.
In regular XSLT, this works if you have a .NET extension set up:
Then call your column names in xsl:value-of statements to access the XML data. Eg, <xsl:value-of select = "columns" />
I haven't used SQL Helper, so I'm sorry if this is irrelevant. But this solution works without SQL Helper.
is working on a reply...