-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi, I am unable to retrieve any data from my cfquery. Same query when i run in sql developer i get the result.
Any reason why ?
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
executing the following query in SQL management studio provides results, whereas it does not via cfquery...
select distinct locationid, locationname, locationaliasname
from vwLocationsWithAlias
where 1 = 0
or (LocationName = N'the' or LocationAliasName = N'the')
or (LocationName = N'the republic'…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
In my CF component, I tried to filter data from user input (getSearchString) and run the code, I having problem with WHERE function. Can suggestion what is the correct way?
<cffunction name="getParks" access="remote" returntype="struct">
<cfargument name="page" required="true" />
<cfargument…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi I have a query which retrieves Some data. I want to display that data considering some conditions in different div tags.
Now my question is, I am doing this by looping the query once and getting the data in three different structs and using these structs while displaying. Is this a good approach…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I am writing the cfquery inside the cfoutput tag. It can be written outside the cfoutput tag. My question here is do we have any performance issues if we write the cfquery inside the cfoutput ?
>>> More
