I don't see any logic in your code that accounts recordcounts from the database that are not divisible by 4. Am I reading it right?

Try the MOD command, on for size.

Make the database field... MEMO and not Text.

Great News!!!

Anytime... so glad I could help...

Actually you allowed me to shake some of the web's of my ColdFusion skills, I haven't programmed in CF in almost 1 1/2 years...although I...

Honestly not sure... like i said, Access has some wierd little quirks with the way it reads SQL statements, in certain situations.

I would say... give it a shot... try any combination of...

Okay... that's how I thought you were using it.
SO my thought would be that outlook is having issue with the >= & <=
I have performed queries like this in mysql but can't recall doing it in access....

Okay...

Question... why is the end date significant are you attempting to syndicate.

IF StartDte and EndDte are both #CreateODBCDate(NOW())# Then it seems like the ENDDte is not necessary.
...

Try USING #CreateODBCDate(Now())# instead of DateFormat.

I see it appears to be an issue with the data type in the database. What field type is beginDate and EndDate? I did something very similar with another application, and ran into issue with ACCESS...

What is your issue specifically? What error do you get or not get?

One issue could be access way of formatting the Date:

Try Removing the mm/dd/yy mask

Techniner,

My repsonse was in now way a Microsoft Endorsement... I was just saying the CF works fine if you have to use it in a microsoft setting... Just a well as any other product running on...

I have to disagree with the windows observation, I ran 3 pretty high traffic webservers on WIN2K, and ColdFusion... I never had any issues with ColdFusion...The JVM gives can be a bit of a memory...

Sure:

Using the CFIF statements to check against parameters that are defined in the form, and create a Where statement based upon present Parameters.

In ColdFusion there is no need to give a...

Also if you wanted to combine both fields to one search you can do <cfif> statements within the query to check for values other than blank.

You can then give searches based on Artist and Title, to...

How many records are you dealing with?

Have you considered the "query of a query" route if there are not that many records returned.

Sound like the ColdFusion administrator cannot locate the java files on your system. Is this a developers version of ColdFusion? What OS are you running ColdFusion on? Do you know if a Java Virtual...