I have a page that consumes a .NET web service and am trying to replace a couple of characters that are coming down in one of the fields with their HTML equivalents.
Here's the gist of it:
...
If I pass an empty field into a stored procedure like so:
<cfstoredproc procedure="myProcedure" datasource="#Application.DSN#" debug="yes" returncode="yes">
<cfprocparam type="in" cfsqltype=...
I am trying to install ODBC drivers for Excel on a server that is running Server 2008 64 bit. There is no option to add an Excel driver in the ODBC setup box. When I use the 32 bit ODBC setup ...
I have two queries with columns year and value. I want to subtract value in one query from value in the other and store the result in an array or structure. Then I need to convert the array or...
We just reinstalled ColdFusion MX7 on a Windows 2000 server. This machine used to have an old version ColdFusion MX 6 on it, but that has been uninstalled. There seem to be remenants from the ...
I am using Coldfusion MX, with an access database. Having just used a form to enter a record, I now want a query to pull off THAT record so I can link other data to it.. as primary key is an a...
is it possible to create a line break in a Javascript "Alert" box? I was thinking a Hex or ASCII character.
Thanks.
Phil
Hi, what is the sql statement to convert a varchar to a number. I'm trying to run a query that grabs all prices that are either less than, more than, or equal to a value but need to convert t...
I would really appreciate it if someone could explain to me in detail how file upload works.
The reason I am asking is because a client of ours has implemented a global filtering system on ...
I'm having trouble executing some PL/SQL from CFQuery using a DSNless connection to an Oracle Database. The Coldfusion Server is Version 5. Any help would be apprecipated!
Here is a snipp...
Hello,
I have 3 values being submitted via a web form. The first is a date mm/dd/yyyy and the second is a time (hh:mm am/pm) and the 3rd is the timezone (EST, CST, MST, PST). How do I combine...
Hi!
I have a multiple choice question page, as follows:
Questions: ---
answer 1, 2, 3, 4 in radio button.
Now, here are my problems:
1 - sometimes there is 10, other times 15, 17, 20,...
Hi i have been running a test on the last page of my project and i cannot seem to get over the error that comes up. can someone explain where i am going wrong. the error is :
String index...
I know how to destroy session variables but am encountering some problems. Below is the description of the problem.
Description
-----------
I am trying to create a website but requires us...
Hello again folks. I created an oracle database, specified the passwords for SYS and SYSTEM and specified the username/password for the repository also.
I then go to CFMX Admin and create ...
Dear experts,
I cannot explain my self why the following code does not show a "hand" cursor.
<select style="cursor:hand;"><option>something</option></select>
Why doesnt' it work?
T...
I've got a table that starts off with a date on top row, then a load of asorted data. Within this data, there's a value field which I need added and written next to the date on the top row.
...
I have created the following CFC based on a UDF I found online somewhere. It basically creates a .ics (iCalendar) file that is e-mailed to a client. The event is accepted by iCal on the Mac ...
Is there anyway when uploading a word document to convert the main body of the document to text/html for storage in a varchar or similar column in SQL server instead of those dreadful BLOB fie...
I have a number: 64118.56
How do I round this to 65,000?
I've created a stored procedure in microsoft sql 2005 db. I am trying to pass just the filepath, filename, size right now because they are all new records im inserting.
Why is it that in...
I am trying to open a new window on an <cfinput type="button">. The window should be a javascript window
and should be able to contain dynamic url variable references, I have tried the follow...
Hi I do not know much about soap requests, but I need to make one and do not know where to put the soap action. So far I have my code like this:
<cfsavecontent variable="theSoap">
<soa...
Hello,
I have been trying to get a piece of code to work on my server. I know the code works but I am not sure what database this was originally designed for. I am using MS SQL and CFMX 7...
I have a field in my MS SQL 2000 db that is a TimeStamp datatype, which is stored as a binary field and i cant for the life of me figure out how to output the data (in coldfusion). i get erros...
