I Am coming to a problem where I am trying to convert my sql statement to do the same logic in cfml (cfscript>) so, I am trying to mimic this sql statement to display the results inside my cfscript. can somebody help me solve this issue? thanks for the help. SQL: Answer @Scott, I am assuming that: Each row from
Tag: coldfusion
How to update columns only if argument is equal to specific value?
I have query that should update columns only if argument is equal 1. Here is example: I would like to move this SQL query to stored procedure. How I can achive the same process with SQL code only? Instead of <cfif form.status eq 1> title = @title,</cfif> how that can be replaced with SQL code? I use Sybase database and
How to handle umlaute like Ä Ö Ü in Coldfusion SQL query to insert into database?
I want to insert a string into my database with Coldfusion. However it contains umlauts like Ä, Ö and Ü (German). The umlauts are displayed different than they should in the database. For example I …
Query null values
I have the column deletedTime in my instances table. Now I want to check in ColdFusion if the value is null. There is only one record to be printed out with the query. IsNull(test) is returning the …
Problem with the value portion of a drop down menu in ColdFusion
Here is what I have inside of my select statement: Everything works fine, but the value it passes to my URL filter is #CountryName#, not the actual country name (i.e. Canada). How can I assign it the value of the country name and not the variable name? Answer The #CountryName# variable is not being evaluated because it is outside your