Subject: AW: [xsl] conditional <sql:column> ?! From: "Szabo, Patrick (LNG-VIE)" <patrick.szabo@xxxxxxxxxxxxx> Date: Tue, 23 Sep 2008 14:44:57 +0200 |
Okay, i4m using your statement now, but now there is another problem: I get the following error: SXSQ0004: SQL INSERT failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '{concat($art,'_',$gericht)}' The error points to this statement: <sql:insert connection="$connection" table="concat($art,'_',$gericht)"> .... The value of concat($art,'_',$gericht), seems to be alright and if i set a static value for table everything works fine though the value that i input staticly and the value of concat($art,'_',$gericht) are the same. cheers Patrick Szabo EPD / XSLT Konvertierung Tel.: +43-1-534 52-1573 Fax.: +43-1-534 52-1573 patrick.szabo@xxxxxxxxxxxxx LexisNexis Verlag ARD Orac GmbH & Co KG Marxergasse 25, 1030 Wien FN 8333f, Handelsgericht Wien www.lexisnexis.at -----Urspr|ngliche Nachricht----- Von: David Carlisle [mailto:davidc@xxxxxxxxx] Gesendet: Dienstag, 23. September 2008 14:15 An: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Betreff: Re: [xsl] conditional <sql:column> ?! > I guess in that case you have to use > <xsl:choose> > <xsl:when which would look a bit less scary if you did <xsl:for-each select="/ris:result/ris:data/ris:risdokument/ris:metadaten"> <xsl:choose> <xsl:when test="ris:technisch/ris:organ='OGH' and ris:judikatur/ris:doktyp='T'"> <sql:column name="DOKNR" select="normalize-space(replace(ris:technisch/ris:id,'_','/'))"/> <sql:column name="Datum" select="normalize-space(replace(ris:judikatur/ris:datum, '-', ''))"/> ... David ________________________________________________________________________ The Numerical Algorithms Group Ltd is a company registered in England and Wales with company number 1249803. The registered office is: Wilkinson House, Jordan Hill Road, Oxford OX2 8DR, United Kingdom. This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. ________________________________________________________________________
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] conditional <sql:column> , David Carlisle | Thread | Re: AW: [xsl] conditional <sql:colu, David Carlisle |
AW: [xsl] conditional <sql:column> , Szabo, Patrick (LNG- | Date | Re: AW: [xsl] conditional <sql:colu, David Carlisle |
Month |