Search results for query: *

I believe I have it setup right. Here is the error I am getting. My primary key is persons_id and it is set up as an auto number. ------------------------------------------------------------ ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC Microsoft Access Driver] The...

By #DSN# do you mean my &quot;smile&quot; datasource or is that a reserved tag or something <CFQUERY name=&quot;getID&quot; datasource=&quot;#DSN#&quot;>

So the following information - - - goes on my insert page? CFQUERY name=&quot;getID&quot; datasource=&quot;#DSN#&quot;> Select * From EmployeeTable Where Username= #Form.Username# AND Password = #Form.Password# </CFQUERY> <CFCOOKIE name=&quot;VerifyLogin&quot...

I am not sure how to incorperate the verifylogin into what I have. I am new at the coldfusion thing. Anyways Below is my login page. When the user submits is login and password, it then is posted to display.cfm where I have used <CFINCLUDE TEMPLATE=&quot;smileauthenticateusers.cfm&quot;> for...

How would I go about using the Cookies option?

I have created an user administration in coldfusion and access and I was curious to whether there is a way to secure a password so that the password given to the user can only be used by that user from a certain computer. That way that user cannot give it out to another person to view with out...

How can I make the following checkbox form (1) work like the radio button input form (2), but with out the off option. I would like to just check on or check off and then update the access database (1)<input type=&quot;checkbox&quot; name=&quot;white&quot; value=&quot;yes&quot; <cfif #white# IS...

Thanks tlhawkins, I should have know that. I think I was looking to deep into.

I have an Access database populated with information such as an autonumber,name,productid,category,subcategory. I need to use a pull down on an admin page to select which category to edit. This is just my form for pulling up active categories. The User then selects from the list and submits. The...

Below is code that populates my Access Database. I need to some how modify this to upload 2 or more images from the same form. It works with the one image valued at &quot;mainpicture_id.&quot; I would like to know how to include a &quot;mainthumbnail_id&quot; as well.. <cftransaction> <cffile...

Never mind my last post, I have it working. Next question is??? How to I input 2 images like a mainpicture and a thumbnail picture?

Ok, I have tried them all and I am still getting some errors. Here is my link to the site: http://66.70.25.16/index.cfm Look towards the bottom...there is an &quot;Administration Login&quot; Click there. login is &quot;mjgrant&quot; password is &quot;grantpassword&quot; and click on Add New...

I am receiving a CFFILE error now. I am kinda getting it but still unsure where to put the cftransaction tag. Below is a small piece of my form and my processing page which returns the user back to an admin screen where I query the database for all the inputs. After the info is input by the...

I am currently writing a coldfusion with access database web site. I am using a form and then posting that form information to another page for processing that contains an CFINSERT for all the info inserted into the database. It works fine. Is it possible to use along with the CFINSERT, a...

tlhawkins Thanks... I don't have to use a random number, it can just be an auto number. So I have tried several ways to insert my data..still no luck. Page 1: default.cfm This page will eventually query for modifing and deleting the database content. Not until I have everything running but...

I currenlty have a working Coldfusion and Access Database web site running for real estate. When a new home is added by the admin, the admin must assign the new home an ID number. Is it possible to have coldfusion/access generate a random ID so the admin can just click on a link that says...