Search results for query: *

I'm getting a Syntax Error on the following statement... <cfquery name=&quot;add_photo&quot; datasource=&quot;domicron&quot;> INSERT INTO photos (id,photo_name,album_id,photo_date,caption,descrip,random,include) VALUES...

First off.... happy holidays to everyone. Hope you're all enjoying time with family and friends. Ok, I'd like to set up a CFIF statment that would allow me to add a piece of text to a page depending on where the user came from. something like: <CFIF http_referrer CONTAINS [sitename]> <p>you're...

Is there a CF5 function that would allow me to display an integer returned by x.RecordCount as English text? ie: 25 displayed as Twenty-five? How can i do it if there is no function? Thanks in advance... -b-

I've been having a problem with an events display page for a college performing group. We want to sort the records by semester and year from the date field and that's been taken care of. The problem is displaying them dynamically. Here's the query: <cfquery name=&quot;events2&quot...

I have this query in a ColdFusion page: <cfquery name=&quot;list_events&quot; datasource=&quot;ksuperc&quot;> SELECT DISTINCT IIF (Month(event_date) BETWEEN 9 and 12,'FAL', IIF (Month(event_date) BETWEEN 5 and 8,' SUM', ' SPR')) as event_semester, year(event_date) as event_year FROM...

Hey all, This CF code: <CFQUERY DATASOURCE=&quot;cfunipix&quot; name=&quot;gallery&quot;> SELECT * FROM photos </CFQUERY> <table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;2&quot; cellpadding=&quot;5&quot;> <table align=&quot;center&quot;> <tr> <CFOUTPUT...

I'm trying to display a single random record from a recordset. Will this code work? I'm at work right now, and can't test it out. <!--- BEGIN EXMAPLE ---> <cfquery name=&quot;random&quot; datasource=&quot;datasource&quot;> SELECT * FROM table WHERE random = True </cfquery> <cfset...

I mistakenly posted this in the ColdFusion forum before i really realized that y problem may be in the query. Here's my goal. One of my old music professors and I have a database of events that are going to be displayed by the semester and year of performance. What I'd like to do is be able to...

I've been having problems with this for the past few days. Here's my goal. One of my old music professors and I have a database of events that are going to be displayed by the semester and year of performance. What I'd like to do is be able to populate a pulldown link menu like what I've just...

Hey all, I have a CF template with two &quot;DISTINCT&quot; SELECT statements. I'm using both of them to narrow down two database fields to only unique values. Then I'm using those two queries to populate one form to pass off the variables. The problem I'm having is when i try to pass off the...

I'm using ColdFusion to fill in form entries in an update database application. Everything is working fine except when I have a multi word value in a field. The form only displays the first word. Is this an MS Access problem or a CF problem? Thanks in advance -b-

I'm using ColdFusion to fill in form entries in an update database application. Everything is working fine except the following: When I have a multi word value in a field, the form only displays the first word. I don't think that this is a ColdFusion problem. Does anyone know how to get...