Search results for query: *

Hey, I have this error "General error: Column count doesn't match value count at row 1" I take this to mean I am trying to insert 4 columns into a 5 column table.. sort of thing.. I have in this orderitems table (this holds the items related to the order) These are the columns. id, orderid...

Hello, I have a memo field in my database - but sometimes I need to show a small image.. I have it all working although the image is always at the top. Is there anyway to say put it at the start of the third paragraph. All the data in body is in html, and contains <p> and </p> I guess I...

I have been storing passwords in my database like so... <cfset enc_password = ToBase64(Encrypt(form.password, form.password))> No for the world of me I can't figure out how to reverse it... I am making a password reminder that is emailed - which is done - the only thing is how do I convert the...

Hello! I would like to know if I can use CFCs to write to a database, passing the data from a form. Does anyone know how to do this? Here's my first cfc - that pulls info from the db <CFCOMPONENT> <CFFUNCTION NAME="ListCategories" HINT="ListCategories" ACCESS="remote" RETURNTYPE="query">...

Hello everyone, I've had a really bad week! I lost my c: drive - not literally, but it decieded to die - and I had to format it :-( Now before the crash - all was fine. I have CFMX, MySQL and Apache (20.0.49)... running really great together - although it took ages... and these three are on my...

Hello, I've installed apache on my machine, along with mysql - and they work great! I can create and use mysql databases - and they work great! I can only use coldfusion files on the inbuilt webserver localhost port - 8500 - not the new one. The only problem being - is that on the new...

Hello, I am just finding out how to wite CFCs - but would like to know how to make them interact with forms.. I would like a form that has two functions - add and amend. Can this be done? Thanks

Hello, Just wondering if anyone knows how to make my application easier to code. I have just looked at it and I have action pages for all the things I want to do. One for add, one for amend and another for deleting a record. I've looked into fusebox - and I find it too dificult for now (given...

Hi! I am devloping a site aimed at doctors, healthcare workers - who mainly work in hospitals. I want to be able to use flash... if they have it... but if not show a JPG in it's place.. We need to avoid the download flash - as in healthcare there is an awful lot of security inside hospital...

Hi! I am devloping a site aimed at doctors, healthcare workers - who mainly work in hospitals. I want to be able to use flash... if they have it... but if not show a JPG in it's place.. We need to avoid the download flash - as in healthcare there is an awful lot of security inside hospital...

Hello, I have written my site, I have a members area and they can login and view the members area. I would like it to end the session and log them out on browser close. At the moment my code says, you have x minutes untill you can login again. Is there a way that kills the session when the...

Hello, I am trying to get a countdown to a time in hours. The time I want to countdown to is Fridays at 22:00 (10pm) Is there a way I can count down to this town only displaying whole hours.. eg 36 hrs to go Also, when it gets to 22:00 and until 03:00 (3am sat) I would like it to say...

In a form I have a form field for a telephone number. I would like to convert it from this &quot;07712 123456&quot; to this &quot;447712123456&quot; As you see I need to remove the spaces and the leading zero and replace the leading zero with 44. Can anyone help?

Hello, I have a provider that uses a POST method to my cfm page to trigger an event on my server. I would like this in turn to make another descision and then do something but it doesn't work! <CFSET datesent=&quot;#lcase(dateformat(Now()))#&quot;> <CFSET...

Hello, I have an Access Database and I am moving hostingt companies... It works on the old host but not on the new.. is this because of they have CF MX? The code is really simple: <cfupdate datasource=&quot;project03&quot; tablename=&quot;traxhome&quot; formfields=&quot;traxhomeid...

I have a form, whereby users can enter some text that will show on a website. I would like to stop html, but allow certain ones like bold, Italics etc I would also like to convert &quot; into the & quot ; version. (the spaces are here so you don't see it converted) Is there an easy way to...

Hello, how can I replace &quot; and ', and other chars as & with nice versions such as &quot; etc here's what I have! <cfset form.desc = replace(form.post,&quot;&quot;&quot;,&quot;&quot;&quot;> But it don't work!

Hello, I have a problem. I am writing a video list for home in CF. And am having no problems until today. I have a table called films - this has its name, decription, director etc. But also contains three fields called genre1, genre2 and 3. These are the ID numbers of the genre table. for...

Hello, Could anyone help me.. I would like to find out the ip address of my hosting (they wont give me the IP) but I have been having trouble with DNS (which is another story) I would like to determin the ip adress of my hosting - how would I do this in CF. I have tried CGI variables and they...

Hello, I would like to have a page that does a number of functions in one page. How would I go about it? I have a page... this page will show results from a query in a list. At the end I want to have a form to add in a new record. I don't want to use fusebox stuff - 'coz it too complicated...