EasyCFM.COM ColdFusion Forums / MS Access Related Issues / Access database insert

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Access database insert -- page: 1 2

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

gurpreet
06-24-2005 @ 12:05 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 18
Joined: Jun 2005

Thanks for this, I have resolved the issue, but when i login and Edit company info, It Shows the all Companies registed information means display all the records registered under the jobad table, i tried several methods but in vain, and I have also a date function which will automaticaly be added when Records ibnserts,

but it inserts date as 5/15/1894

Why so? please revert soon for an andswers.

and else I have used query as the:

select * from jobad where ________ condition i don't know what to write help meee

Gavy Randhawa

megan
06-24-2005 @ 12:20 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2398
Joined: Jan 2003

OK - You need to learn sql - try this link

Learn SQL here

Also learn SQL here

hth ~megan

We have art so that we shall not die of reality ~ Nietzsche

This message was edited by megan on 6-24-05 @ 12:21 AM

megan
06-24-2005 @ 9:15 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2398
Joined: Jan 2003

after some sleep I realized tht it may not be the sql you are wanting to know. So what you want to do is

select * from jobad where jobadid = #thisvariable#

to learn basic coldfusion and get an idea of how it works why not try out a few of the tutorials in the beginner section http://www.easycfm.com/tutorials/index.cfm?type=1

also take a look at:

Getting Started Building ColdFusion MX Applications

hth ~megan

We have art so that we shall not die of reality ~ Nietzsche

gurpreet
06-25-2005 @ 8:30 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 18
Joined: Jun 2005

Thanks I got the solutions.. I am Posting this on my website now:

Gavy Randhawa

megan
06-25-2005 @ 10:08 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 2398
Joined: Jan 2003

I'm glad I was able to direct you to the information you needed Wink  ~megan

We have art so that we shall not die of reality ~ Nietzsche

PAGE: 1 2

Website Designed and Developed by Pablo Varando.