[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] AW: conditional <sql:column> ?!
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: 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. ________________________________________________________________________
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|