Search results for query: *

Hi r937, thanks for the reply. The reason is the users will be performing this task and I do not think they can use LOAD DATA INFILE command - we are talking about basic users. so if I could get coldfusion to purify the data and then store it it would save us from manual repetitive job which...

Hi, I am trying to loop through a csv file wich comes with column headers but the trciky part is some of the headers(1 or 2) are missing and I have no control over how it comes back. Is there anyway that I can skip or replace that header with a decent title? The end product needs to be...

Hi DonQuichote, thanks for your response. I use mysql 5 with mysql Front as my front end to the dbase server(i do run my dbase queries here). I use dreamweaver as my editor and it is currently set to utf8 as the default - I know that cos when i create a blank page i get this line at the html...

Hi there, unfortunately this does not seem to do it for me. I am using mysql5 and coldfusion. The text in Russian displays properly when hard coded into the webpage. But when I try to do an insert it simply becomes "????", when I type it directly into the database field it changes to "???" as...

I have managed to do this and displays one image.But how can I display more than one image on for say one property. Do i need more than one directory(in the webspace) Please give me more details and examples. I have never done anything like this before.

Hi there, I've tried googling this but no results. Here is what I need to get properties from a database and display them with their pictures.(gallery) I know storing pictures in the database is not good performance wise. Has anyone have any tips on how to do this in coldfusion? Thanks

Hi there, I have posted this on MYSQL forum as well but no answer so I will try here!! I would like to know if it is possible to insert xml data into mysql database table in a structured way and if yes what syntax...any help is appreciated!! Thanks

Hi there, I would like to know if it is possible to insert xml data into mysql database table and if yes what syntax...any help is appreciated!! Thanks

Hi I have to invoke a web service from a third party. They have sent my company a CD with the WSDL files on. I have noticed that coldfusion uses url to wsdl to access the web service....does any one know any trics to this?? I am thinking of hosting this wsdl file on locsl and call it from...

I have a table and with an increment ID which id now SN001 but i would like to add an extra 0 to make it SN0001...any idea how to do this?? I tried update like this UPDATE CUSTOMERS SET CUSTOMER_ID = "SN0+[CUSTOMER_ID,4]" Thanks

SORRY I WANT TO DO THIS IN MYSQL

I have a table and with an increment ID which id now SN001 but i would like to add an extra 0 to make it SN0001...any idea how to do this?? I tried update like this UPDATE CUSTOMERS SET CUSTOMER_ID = "DL0+[CUSTOMER_ID,4]" Thanks

Hi there, I am trying to page through records using a little bit of java as below....my problem is not displaying the data...The first block displays correctly but the second and the third are all over the places...I have tried all sorts of formating, it's not happening....Can some one spot...

Hi there, this is almost working but it is only checking if password box 2 contains something...if i type anything else it allows it...below is my code: <cfhtmlhead text="<title>#variables.SiteName#</title>"> <cfif #Form.user_password# eq #Form.user_password_retry#> <cfelseif...

Hi there, I am having a problem validating user input. When a user is registering, i need them to create a password and confirm it using another textbox field and then submit it to the database. I have created the form and submits correctly but need to match the two password strings entered on...

thanks that helped

Sorry, still not working with a fresh error: Element USERS is undefined in FORM.?

Hi, I think it might be something else cos i still get this error: Element USER_NAME is undefined in FORM. Thanks Critical5

thanks Wullie, the first problem is sorted but the second one is still not working...i get this error: Element USER_NAME is undefined in FORM1. i think it is defined in the following form or not?? <FORM METHOD="POST" name="form1" ACTION="users_report.cfm"> <SELECT NAME="users">...

Hi there, here is what I am trying to do: I am filling a drop down box from the users table: <cfquery name="Users" datasource="mysource"> select USERNAME from users where users.user_department='HR' </cfquery> This works fine but i also need to add to the list the users from sales....How do i...