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
what's the syntax for join two tables in sqlhelper?
Not sure what you mean? The table joins are done via the SQL.
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:
Image will be uploaded when post is submitted