Search results for query: *

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...

<cfif IsDefined("FORM.Submit")> <cfquery datasource="WTGI" name="insert_rec"> INSERT INTO emp_app ( app_date, last, first, VALUES ('#FORM.app_date#', '#FORM.last#', '#FORM.first#', </cfquery> </cfif> <cfmail subject="A new application has been submitted" from="admin@company.net"...

Thanks for responding. When I use the syntax you gave me, i get an error saying: Element APP_DATE is undefined in FORM Is it because of the pound signs? When i use it without the pound signs it works, it just doesn't show any of the answers.

    <cfmail subject="A new application has been submitted" from="admin@company.net" to="hr@company.net" type="html"> <table width="48%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="265"><div align="right">Date: </div></td> <td width="200"><input name=value=form.app_date...

Heres the code with an example of the fields i am using: <cfmail subject="A new application has been submitted" from="admin@company.net" to="hr@company.net" type="html">

Im submitting an online application to itself through email. I added the value=#form.formfield# to the fields. I also added type = html to the cfmail tag;which worked fine. It shows the whole html,but, it is not showing any of the answers in the field within the cfmail tags. What should I do...