storing xml in sql

Hi there, If you are still wishing to go down the route of XML after the previous posts, you might wish to externatize some specific nodes in your XML data. That way the value of particular nodes and particular atttributes are stored seperate from the XML in another table with the ID of the

CFMX 6.1: floats being read from DB are truncated?

Hi there, We have just upgraded to CFMX 6.1 and we are having an issue with either CFMX, or the JDBC drivers reading from our SQL 7 database. The problem centers around any float field in the DB, (e.g. 1.0). I can look it up the value of this field in SQL query analyser and get '1.0'.

CF in XSL, passing variables

I think I know what you are trying to do, and it's simply not possible. You want to be able to access a variable like a URL variable in a HTML page from within your XSL page. There is a way to do this in Java's implementation of XSL, but not the flavour that Cold fusion have given us. I even

CFMX 6.1: floats being read from DB are truncated?

Hi there, We have just upgraded to CFMX 6.1 and we are having an issue with either CFMX, or the JDBC drivers reading from our SQL 7 database. The problem centers around any float field in the DB, (e.g. 1.0). I can look it up the value of this field in SQL query analyser and get '1.0'.

storing xml in sql

Hi there, If you are still wishing to go down the route of XML after the previous posts, you might wish to externatize some specific nodes in your XML data. That way the value of particular nodes and particular atttributes are stored seperate from the XML in another table with the ID of the

CF in XSL, passing variables

I think I know what you are trying to do, and it's simply not possible. You want to be able to access a variable like a URL variable in a HTML page from within your XSL page. There is a way to do this in Java's implementation of XSL, but not the flavour that Cold fusion have given us. I even

CFMX 6.1: floats being read from DB are truncated?

Thanks for the feedback. I will look into the numberic datatype instead of float. In terms of NumberFormat(), we use this for display purposes, but what is frustrating is that in the course of a script we can get an incorrect mathematical result, and so we have to make changes to a number of

CF in XSL, passing variables

I think I know what you are trying to do, and it's simply not possible. You want to be able to access a variable like a URL variable in a HTML page from within your XSL page. There is a way to do this in Java's implementation of XSL, but not the flavour that Cold fusion have given us. I even

CFMX 6.1: floats being read from DB are truncated?

Hi there, We have just upgraded to CFMX 6.1 and we are having an issue with either CFMX, or the JDBC drivers reading from our SQL 7 database. The problem centers around any float field in the DB, (e.g. 1.0). I can look it up the value of this field in SQL query analyser and get '1.0'.

storing xml in sql

Hi there, If you are still wishing to go down the route of XML after the previous posts, you might wish to externatize some specific nodes in your XML data. That way the value of particular nodes and particular atttributes are stored seperate from the XML in another table with the ID of the