•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 361,901 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,419 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ColdFusion advertiser:
Views: 6558 | Replies: 16
 |
•
•
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....
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb ColdFusion Marketplace
Linear Mode
•
•
•
•
advertising apple blogging business community copyright crime development email environment firefox gaming google hacking hardware ibm internet ipod law legal linux malware marketing microsoft mobile mozilla myspace networking news red hat research satnav search security skype social networking software spam storage survey technology trends trojan tv ubuntu virus vista web windows youtube
- Previous Thread: code error
- Next Thread: Help with a search form/page
