ColdFusion Forum

I am facing some problem when connected my cold fusion 5 application with SQL Server 2005 database. If the table fields are nvarchar the the cfquery is retreiving as null. Except the nvarchar filed everything is retreiving perfect.Any idea on this?

Hi, I have a query which updates the projects table of my database, however when I try to run my query with blank values i get the following error: Data truncation: Data truncated for column 'date' at row 1 I have done some researching and I believe the problem is to do with the data that is being sent by my cfqueryparam function. Here...

Hi, I'm trying to figure out the best method for uploading a number of files along with entering some data into a database using a component containing CRUD methods. I have the following file structure: index.cfm - Controller file - display / - create_update.cfm - Contains form for creating and updating a project com /

Alright, I feel like this is easy, but I haven't been able to figure it out: I have two database tables which I need to gather information from and output on a coldfusion page in a table. I know I can output the data I need in a row with: <cfquery name="list" datasource="abc"> select pkey, summary, stringvalue, numbervalue from...

I have a scheduled task that I setup in the CF administrator. It calls a page which runs some queries and inserts some data into tables. I checked the output file, and I'm getting this error: HTTP 401.2 - Unauthorized: Logon failed due to server configuration I'm using Integrated Windows Authentication on my site because I'm using LDAP...

Hi there, I'm replicating the look of an Access form in Coldfusion In Access I can create group headers to sort my data, so all the jobs under a particular site appear under that site name - which appears only once. I'm using a cfloop query to get all my results in CF so my site name is repeated constantly. - like so Site: MYSITE1 Job1

Snippet: <form> <select name="secCode" id="secCode"> <cfloop query="Request.qSecCodes"> <option value="#Request.qSecCodes.org_name#" <cfif (Request.qSecCodes.org_code EQ Variables.oSurvey.secCode)>selected="true"</cfif>>#Request.qSecCodes.org_name#</option> </cfloop> </select> </form> As you can see, I'm populating that select...

hi, please i need to get my pictures automatically resized when i upload them, the resize shoild happen before it saves a copy to the image folder

I have collection object. Its recordset has the results of a query. And I have a form. Let's say that the form saves the user's first name. I want to be able to loop though that collection and compare the "firstName" value in the query to what the user has entered in the text input field. If it exists then don't submit the form. I will add some...

After I query an sales table, i would like to add the outstanding unpaid to another table Output example id_order company amount 3 A 30 4 B 40 6 C 45

Hey Everyone, Well for the last few days i been trying to figure out how to delete attachments and download attachments to my computer. The deleting is sort of working and i don't know where to begin on downloading. Right now with the deleting it will delete from the attachments folder on the server but it does not delete from the database an...

Hi , I have a radio buttons yes and no. when i check "yes" it has enable the two dropdownboxes and when i check "no" it has to disable the two dropdownboxes? can anyone send me the code. Thanks,

Hey Everyone, Well recently i been inserting multiple fields for a section in my form called "serial". Well now i am trying to insert multiple fields for the not only the serial section but also the parts section an i seem to be having trouble. When i try to insert into the parts section i get the error Invalid character value for cast...

Hey Everyone, What i am trying to do is show previously entered information. I know i need a loop for this , but i am not sure how to loop through this based on my form appears all in the javascript here is my code <cfquery name="serial" datasource="CustomerSupport"> SELECT...

Hey Everyone, i been working on trying to understand the URL method of retrieving information for the last week, but i am stuck. I been able to get one table of information, but now i need to get 3 tables of information at the same time an i am running into trouble. Each table has a number in common with the other, each has a field that holds...

1. If i need to add into the database time now() of singapore time, how do i do it?? now() + ______ 2. If I need to output the time now of singapore , how?? <cfoutput>#now() + __________#</cfoutput>

I got one last question. Its more related to my question about the serials and would post it in that forum but we already closed it an i think its a simple question, if it needs a new forum let me know :). When i was testing out insertinga description and a resolution (both textarea fields).When i go to submit i noticed a problem.if you put any...

Hi, I am running a report using Cold Fusion. This report is generated by cfloop tag. Depends on the record count of a query, the report will list the data retrieved from the database. each row in the report will have a radio button, so there may be lots of radio buttons in this report. These radio buttons are defined in a form tag. User will...

Hi! I have data returned from a database displayed on a webpage for amending. A date on the form is selected using a pop-up calendar which returns it to Access. When the date is retrieved the dateFormat function is used to display it as dd/mm/yyyy. However, when I run an update query, allowing the user to change any field and refind the...

Hi, How do I insert a null or blank field into a database using coldfusion? I'm new to CF and its proviing a bit tricky! My database date field accepts null values (I think - theres no default value or validation rule). The input box on the form is this: <input type="text" name="QuotePDate" maxlength="10" size="12" /> and is handled...

I have these values for my cfgridcolumn called 'phrase': href="#Request.self#?fa=#XFA_choices#&phrase="hrefkey="phrase" I can see the value of the phrase cfgridcolumn at the end of the URL but I'd like to be able to add another hrefkey because I want the href to contains the values of (in layman terms): URL + value of phrase cfgridcolum + ...

I would like to change all my sub folders name within a main folder, how do I do that??? like: - app1 amm1 ann1 to app1pp amm1pp ann1pp

Hey Everyone, Well this is my first time asking a question on here so please forgive me if i post my question in the wrong section. What i am trying to do is upload multiple files like gmail does. I found a script that does this on easycfm.com (Topic 13543). But anyway when i try to upload multiple files it will create multiple records...

Hello everybody! My problem is quite dummy. I have 2 pages: city.cfm - parent metro.cfm - page to include I want to load and see the content of metro.cfm inside cfdiv tag of city.cfm, after I've clicked the specified link (<a name="toggleMetro">Metro</a>). I've tried to do this in city.cfm: bind="url:metro.cfm{toggleMetro@click}"...

I'm working on a calendar that works well in all points except one. I found the code online and modified it to fit my needs. One of my mods isn't working. I'm trying to make it display the chosen month under the drop down box but I'm getting and "Element MONTH_VAL is undefined in FORM" error. It seems to be defined to me but I could be missing...