Please support our ColdFusion advertiser: Programming Forums
 |
•
•
Join Date: Jul 2005
Posts: 8
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I'm currently not home at the moment. What if I put the EndDate >= .
Like so:
WHERE BeginDate = #CreateODBCDate(Now())#
OR EndDate >= #CreateODBCDate(Now())#
Like so:
WHERE BeginDate = #CreateODBCDate(Now())#
OR EndDate >= #CreateODBCDate(Now())#
•
•
Join Date: Jun 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by fbalangue
I'm currently not home at the moment. What if I put the EndDate >= .
Like so:
WHERE BeginDate = #CreateODBCDate(Now())#
OR EndDate >= #CreateODBCDate(Now())#
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 things...sooner than later you gonna get it to work. You seem very close.
•
•
Join Date: Jul 2005
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Torch7!!! Thank you so much for your help! I just got back and tested what I had from last time. IT WORKED!!! You've been a great help and support! Thank you! Thank you! Thank you! I'm so excited!!!!
•
•
Join Date: Jun 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 1
Newbie Poster
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 really miss it.
Some of the Greatest CF Tools for me have been without a doubt, the ColdFusion Web Application Construction KIT...by Ben Forta.. (worth the price)
Macromedia live docs.
http://livedocs.macromedia.com (again worth the price **FREE**)
and This is also a great tutorial site.
http://www.easycfm.com
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 really miss it.
Some of the Greatest CF Tools for me have been without a doubt, the ColdFusion Web Application Construction KIT...by Ben Forta.. (worth the price)
Macromedia live docs.
http://livedocs.macromedia.com (again worth the price **FREE**)
and This is also a great tutorial site.
http://www.easycfm.com
•
•
Join Date: Jul 2005
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Thanks Torch7. I just thought about something else. How do I create an entire multi-paragraph item? I looked at the database and saw that the limit for text is 255 characters.
My example would be after the user selects the headline item and views the details of that headline which is less than 255 characters(no problem). Now lets say I want to elaborate on the story. I'm still thinking on this one.
My example would be after the user selects the headline item and views the details of that headline which is less than 255 characters(no problem). Now lets say I want to elaborate on the story. I'm still thinking on this one.
•
•
Join Date: Jun 2005
Posts: 15
Reputation:
Rep Power: 4
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by fbalangue
Thanks Torch7. I just thought about something else. How do I create an entire multi-paragraph item? I looked at the database and saw that the limit for text is 255 characters.
My example would be after the user selects the headline item and views the details of that headline which is less than 255 characters(no problem). Now lets say I want to elaborate on the story. I'm still thinking on this one.
Make the database field... MEMO and not Text.
•
•
Join Date: Apr 2006
Posts: 27
Reputation:
Rep Power: 3
Solved Threads: 1
Light Poster
i had a similar kind of an issue with MS SQL Server which also supports only 255 characters for the text field.
i solved it by making the text field to varchar of teh desired length i wanted.
le me know if this works out....
i solved it by making the text field to varchar of teh desired length i wanted.
le me know if this works out....
|
Other Threads in the ColdFusion Forum
- Previous Thread: code error
- Next Thread: Help with a search form/page
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
