Search results for query: *

Is there a way to use a checkbox selection to place an "X" inside the appropriate box?

hello all, new to this forum. I have a problem hopefully someone can shed some light on. We have a client for whom we created an online shopping cart. Once the person places the order and checks out a confirmation email is sent. This worked fine until the client installed an exchange server...

hello all, new to this forum. I have a problem hopefully someone can shed some light on. We have a client for whom we created an online shopping cart. Once the person places the order and checks out a confirmation email is sent. This worked fine until the client installed an exchange server...

Hello all, I have inherited a problem. We have a shopping cart which emails the contents of the cart to the sales address. However, our clients installed an exchange server to handle all the email and now they are not receiving any of the order confirmations. Below is the original code...

Just a quick question. Is it possible to pass form data to a sql statement. For example: on one page a drop down list with a list of the different databases and another area for the table. Can these be passed to the SQL statement with something like: <cfquery name="getinfo"...

Any ideas on how to fix this? This is the line it is referring to: DESTINATION="D:\WWWRoot\safescriptinc.com\www\Employees\HSF" Thanks

Hello everyone....I have a quick question. In my database I need to make a place to upload files in pdf format. Once they are uploaded then they need to be able to be searched and viewed. I don't want to the database to become too big so I was thinking of using a hyperlink field. Is it...

hello I am a relatively new Access user. I am building a program to upload documents to a database. My question is this is the best way to achieve this by setting a field in a table to be OLE and upload to it....or to upload to a location and have hyperlink to that document? Thanks

Hi, I am almost finished with the application however I have one more question. I am trying to tweek the login page but it keeps redirecting me back to the same login page. Any suggestions? forceuserlogin.cfm code <!---Force the user to login---> <!---Thise code only executes if the user has...

Hi, here is what I am wanting to do: When someone enters a new report I want an entry in the date field. Currently I am using Now() in the default field for DATE. I have tried the following Format(Now(), "dddd, mmmm dd, yyyy h:nn:ss AM") however I get a type mismatch error when I enter this...

Hi, does anyone know where I can find a good tutorial for building a search with next and previous buttons? Thanks.

Hello quick question. I have Now() displayed as 2004-07-06 01:36:15.0 I would like it displayed as Monday, June 07, 2004, 1:36:15 PM. What is the correct expression? Thanks!

Hi all....is it possible to enter 2 expressions in a default value. For example in a memo field could I enter say =Now() followed by text? So that each time text was added the time that it was added would be displayed? or am i better off creating another field for Date/time?

I was wondering if there is a way to do the following: I have a table in MS Access called Reporting and another table named Admin. The ID field in Reporting is related to ID in Admin. In the Admin table I have 2 fields ID and Comments. I have a default comment basically stating that "we will...

I have a login page with the following query: <cfquery name="GetUser" datasource="#DataSource#"> SELECT UserID, Username, Password, Company, FName, LName, AuthLevel FROM Users WHERE UserName='#FORM.UserLogin#' AND Password='#FORM.UserPassword#' </cfquery> When I attempt to login I receive the...

I have uploaded my database and have entered AccountExec in the AuthLevel Field. When I attempt to login I get the following error: Element AUTHLEVEL is undefined in GETUSER. The error occurred in line 33 31 : Name="#GetUser.LoginID#, #GetUser.FName#,#GetUser.LName#, #GetUser.Company#" 32 ...

This one has me confused. I have tried using both a SQL statement and a cfinsert statement. Here is the problem...when I type the message in the text area I can use quotation marks and they work fine....however, when I copy from another source (Word, or IE) and paste into the textarea I receive...

DB newbie here - I have MS Access table with the following fields PressID, PRTitle, Month, Day, and Year. Once the information is posted I want to be able to update/edit if necessary. The following is the code I have used to list the current data: With the html removed <cfquery...

I am attempting to update a table in MSAccess. When I retreive the info from the database and when it is displayed the quotation marks show up as a box. How do I enter quotes surrounded by quotation marks using a cfupdate page? Thanks!