Search results for query: *

Oh, I also had to pull the quotes from the Date/Time field but that was a really easy fix. I'm used to changing quotes around on those as I can never remember if they're sent as a string or not. -b-

Here's the generated SQL: INSERT INTO photos (id,photo_name,album_id,photo_date,caption,descrip,random,include) VALUES (,'01.jpg',2,{ts '2000-01-01 00:00:00'},'none','none desc',1,1) This has actually sovled my problem. Here are some questions I have. The ID field is an autonumber, so I...

Here's the error: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document...

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...

not only can you fix my CFML boo-boos... you have good taste in drinks... cheers *hoists one to ya at the end of a really long holiday* -b-

hey rudy... i hope you mean 'GT 0' not 'GT )&quot; right? thanks man, i was actually just spelling the variable wrong... *sheepish look* that was a big help -b-

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...

beautiful... thanks for the resource tooled... helped me out with a couple of problems. -b-

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-

...see. I'm using this: <cfif month(Now()) GTE 9 AND month(Now()) LTE 12> <cfquery name=&quot;events2&quot; datasource=&quot;ksuperc&quot;> SELECT * FROM events WHERE year(event_date) = year(Now()) AND month(event_date) BETWEEN 9 and 12 </cfquery> <cfelseif month(Now()) GTE 5 AND month(Now())...

nope, never mind... i was using the wrong value... fall was 3, not 1... i'm a putz... [blush] If anyone sees any problems though, please let me know -b-

...of. The problem is displaying them dynamically. Here's the query: <cfquery name=&quot;events2&quot; datasource=&quot;ksuperc&quot; debug> SELECT * FROM events WHERE month(event_date) <cfif url.sem IS 1> BETWEEN 9 AND 12 <cfelseif url.sem IS 2> BETWEEN 5 AND 8 <cfelse> BETWEEN 1 AND 4...

Oops, got it now... William and Ken were both really close... I couldn't call 'event_year' as and ORDER BY.... and I didn't need the 'Month(event_date)' SELECT DISTINCT     IIF (Month(event_date) BETWEEN 9 and 12,'FAL',     IIF (Month(event_date) BETWEEN 5 and 8,' SUM',     ' SPR')) as...

First suggestion: [Microsoft][ODBC Microsoft Access Driver] ORDER BY clause (event_year) conflicts with DISTINCT. Second suggestion: [Microsoft][ODBC Microsoft Access Driver] ORDER BY clause (Month(event_date)) conflicts with DISTINCT. ORDER BY either does not work with DISTINCT, or I'm not...

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...

well nuts, that did it... thanks much migit.... -b-

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 think I get it. How's this? <!--- BEGIN EXAMPLE ---> <cfquery name=&quot;get_random&quot; datasource=&quot;datasource&quot;> SELECT count(*) as howmany FROM table WHERE random = True </cfquery> <cfset rec=Int(howmany * Rand())> <!-- WOULD I STILL NEED THIS TO PREVENT ZERO FROM BEING...

I'm just using access. So will this work? I don't think there would any problems. -b-

...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 rec=Int(Random.RecordCount * Rand())> <cfif rec EQ 0> <cfset rec=1> </cfif> <cfoutput...