Recent content by hevychevy1996

well if it is on the screen then it can be printed that way. so apparently both. center aligned, size 12 font, silver color,no images just simply: please contact us at : 800-546-8463 ext.589 is that good?

Is there a coding involved to have a header and footer for my html document? If so, can you please share? thanks in advance

hey bombboy just checking up to see if you found any sqlinserts yet? what about cfqueryparam is that an option as well? -Thanks in advance

I see i haven't got any responses. Is there any other type of coding I can use instead of create ODBC ? Please let me know -Thanks in advance

here is what i receive Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][MySQL][ODBC 3.51 Driver][mysqld-4.1.3-beta-max]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at...

INSERT INTO emp_app ( app_date, VALUES( '#dateformat(now(), "yyyy-dd-mm")#',

i changed it to that format but i am still receiving zeros where i entered the date on the application

This is what i am receiving for a date after an application has been submitted: 0000-00-00 This is what i receive if someone put for example: 2-16-05

ok i used the '#dateformat(now(), "dd-mm-yyyy")#' and it submitted fine. Only now it isnt showing the date in that format in my database? You want me to only change in the values portion corrcect? VALUES( '#dateformat(now(), "dd-mm-yyyy")#', '#FORM.last#',

now when i use your way bomboy i receive this error message: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][MySQL][ODBC 3.51 Driver][mysqld-4.1.3-beta-max]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version...

so where do i put the create odbc format? app_date is the field the users are entering the date into

ok you ask and you will receive: <cfif IsDefined("FORM.Submit")> <cfquery datasource="WTG" name="insert_rec"> INSERT INTO emp_app ( #CreateODBCDate(FORM.app_date)#, last, first, middle, maiden, address_1, address_2, city, state, zip, social_security, phone...

I created an online application submitting to itself. I have the code below for the beginning of my cfquery: I am having a problem with the date. app_date is the date field i am using. When i test it out i receive error executing database query. N E ideas? Thanks in advance...

it doesnt like the hash marks I keep getting an error saying it cannot be found in form: Date: #form.app_date#<br>

My bad. Here you go! [code] <cfif IsDefined("FORM.Submit")> <cfquery datasource="WTGI" name="insert_rec"> INSERT INTO emp_app (app_date,last,first,middle,maiden,address_1,address_2,city,state,zip, social_security,etc...,discharge_date) VALUES...