ColdFusion Forum

hi i need a code for importng a csv file intoa sql in coldfusion

Hi ! Thia is a very basic question. I am absolutely new to coldfusion. I have a web application created in coldfusion. I have copied the whole applictaion directory structure with the files and created a virtual directory linking the same. now when i try to open a .cfm file from IE it shows the open/save dialog box and if i click open, it uses...

i am just entered in cfml.the problem is that i have made a programe, the details r taking two inputs in a form checking username and password from database and if the both the fields match it prints the password.i am sending the court plz help me out as soon as possible. <cfset step = 0> <cfif IsDefined ('#frm.txtusr#')> <cfif frm.step is...

Hi! This might be a very simple query for all those working on Coldfusion but difficult for novice like me. I have to fetch data from the SQL Server database which is on a remote server. Can someone help me with the code that I need to write in the <CFQUERY> tag. I have written the code as: <cfquery name="qry_fetch_user"...

Hi, I am new to coldfusion. I need to query a table to get some datas and then draw a graph using that. Can anyone help me? Thanks Resmi318

Hi! I have configured IIS for coldfusion and when I access my coldfusion site through localhost, the pages are served as required. But if i ty to access it from a remote machine by specifying the IP address in the url, it displays an error: The web site you are accessing has experienced an unexpected error. File not found:...

Hi! I am an ASP.Net programmer. I have been assigned a task to make some modifications to an existing website that is entirely in ColdFusion. However I have no idea about ColdFusion. Is it possible to develop a part of the application in ASP.Net and have a link in the coldfusion page redirecting to this page. Will it have some functionality...

I am very new to Macromedia Coldfusion, I have a user registration form and would like to capture / store & for debugging purposes echo (print) the form data using a CFscript. The form’s name is Registration one of the text fields name is FirstName. I am having a problem referencing the value entered into the field. My reference is as follows ……....

How does one using CF consume a web service that requires a complex data type as input? Example: <complexType name="name"> <sequence> <element name="firstname" nillable="true" type="xsd:string"/> <element name="lastname" nillable="true" type="xsd:string"/> </sequence> </complexType>

I am attempting to loop through a list of string variables to define the values in a group of checkboxes. However, I am having difficulty writing the correct syntax, as the following syntax produces the output shown: <cfloop index="tmpVar" list="Str1,Str2"> <cfinput type="checkbox" name="myName" value=#tmpVar# /> ...

Hi, I'm trying us mySql user defined variables in a cfquery tag, but I keep getting an error. I know the statement should work because I've tested it a mySQL GUI without problems. Coldfusion is taking issue with the SET @var=0; part of my statement. Here is the statement in full; SET @pos=0;

Following the guidance contained in Dreamweaver, I have declared a cflogin tag in the application.cfc file. This declaration contains an idletimeout setting of 10 seconds (N.B. 10 seconds for development purposes only). <cflogin idletimeout="10"> <cfif Not IsDefined("cflogin")> <cfinclude template="./loginform.cfm"> ...

Hi all, I got one brainteaser (well...for me). I have a database with, lets say 100 images, these images are 'dynamic' e.g. it can be 100 but also 151 images. My question is: How can i make a dynamic table where I can set that the maximum columns is 5. So when parsing the images, then CF fills up a row of 5 images (all in a different...

For multiple records of a similar type in a database query, I am attempting to define some checkbox form elements from the query using an array: <cfset temp=ArrayNew(1)> <cfset i=1> <cfloop query="myQuery"> <cfset temp=#myQuery.colName#> <cfinput type="checkbox" name="temp" value="#temp#"/> <cfset i=i+1> </cfloop>

The text <cfinput> elements in my forms retain the previous values that I have typed in, appearing in a drop-down list under the text element. I would like to remove this feature from the form text elements. Could anyone advise me on how best to remove this predictive text feature from my form elements. Regards Blackmore

I have tried to enhance the functionality of my website by adding some javascript functions to augment my hyperlinks. I have not removed the hyperlink as I am conscious that some browsers may have javascript disabled. So the server call needs to be retained if this is the case. However, if javascript is not disabled I would like to cancel the...

I'm trying to build some custome filters for a document reader and one of the fields that I have is the document date (docdate). The customer wants to be able to filter the documents by year and month. For the purpose of the dropdown I wanted to select the distinct years from the docdate column. <cfquery name="yearSelect"...

Hi guys, I don't know whether this is feasible or not. But here is my problem I have a session variable which has database field names in a particular order and this variable is generated dynamically, I dont know what is in that variable and in what order. What I have to do is display my results in the order they are in the session variable....

hi, how can i pass ALL the form variables including grid-data to a remoting-cfc in one big structure? (like the form structure in cf)

To be continued...what that mean? Can some one help on second part of this? The "UploadFile.cmf", I did try to upload the file and save in oracle database but fail, I am having hard time on this issue, can not find any where explanning on this matter. Here is the code, please help, very appreciated. <HTML> <HEAD> <TITLE>Load...

do you have a solution to this problem <cfset monxml=xmlparse(tempfile)> An error occured while Parsing an XML document.

I'm having an issue validating that the "Add" button was selected..... <cfform name="NEW_FORM" action="systemSubmit.cfm"> <tr><td colspan=2 align="center"><h4>Submit New System</h4></td></tr> <tr><td align="right">Name:</td><td><input type="Text" name="name" size="50"></td></tr> <tr><td align="right">Description:</td><td><textarea ...

I've got an enter/edit screen created for people to enter new systems. Before the new system gets submitted I have the submit page query the database to make sure that a record doesn't already exist with that name. If it does, I set the url back to the enter/edit screen. Is there a way I can have the coldfusion popup a message stating that the...

I have this query at the very top of my cfm file. It's right under the <body> tag. The date list which is returned from the query below isn't sorted in DESC order when the page first loads, but it does when you refresh the page. Why does this happen? I'm sorry for these questions, but I don't know where else to ask really. <cfquery...

I'm trying to pass a date/time value to a page so I can refresh the page based on the date/time selected by the user. I'm using client variables for now, but I have to have the form at the bottom of the page so that when I hit the refresh button the date/time is used. Is there a way to pass the value in the URL? <form...