Search results for query: *

I'm having a logic issue with my SQL statement. I'm building a SQL string based on form data. Here's an example of the final WHERE clause: TITLE = 'Advertising Manager' OR TITLE = 'Advertising Assoc' OR TITLE = 'Advertising VP' AND STATE LIKE '%ca%' AND FIRSTNAME LIKE '%Chuck%' My issue is...

I would like to only allow a user to be logged in on one PC at a time to avoid username/password sharing. I would also like to accomplish this without logging them in and out of the database if possible. Right now, I write to an application variable their userid once they login, or check if...

A field in the database contains for example, the word Lowe's with the apostrophe. I want to be able to search for that string. When the apost. is used, CF errors out. I can currently sure for lowe becuase I'm using LIKE in the query however lowes returns none and lowe's errors. Using Access...

I've set about a dozen addresses to forward to from one address on the domain. It forwards to the first 5 or so, then i also get a reply from postmaster stating that one of the addresses is not recognized. Funny thing, the address is cut short by about 6 characters. So, I'm thinking there's a...

Hi All, Been trying to use cfexecute to run f-secure (SSH program). I am trying to connect to an ip that requires username and private key installed on machine. Then i need to pass commands to change directories. Nothing happens though. Not sure how to pass the ip and connect command...

Hello all, I am using compare() and checking for username and password login info. Hoping to use this to make them both a case sensitive check. The database contains a username and password both of frank for example. When the script runs though, it will only take the login if the first letter...

When I make changes to Application.cfm, the changes are not becoming active on the site. I've checked for other Application files on the server, and the others are only found in CFIDE/administrator folders. I've added some code I found here at TT: <META http-equiv=&quot;Expires&quot...

while ($myrow = mysql_fetch_array($result)) { printf (&quot;<a href='calldetail.php?id=%s' target='_blank'>%s</a> <br>&quot;, $myrow[7],$myrow[5]); Using this, the first record is not returned. Only records 2 and higher that are in the databse. Any thoughts. If you need more info...

Hi All, I have five images in the right column of a page. Each image when rolled over changes a main image in the middle of the page. No problem here. How can each new displayed image in the middle of the page have it's own HREF assisgned? The goal is thumbnail on right, midsize in...

I have set: <cfset MyList = &quot;,,,,,&quot;> Then use: listlen(MyList, &quot;,&quot;) this returns 0 where as I need it to return 5. Is there another function I should be using. Ultimately I will be using listgetat to retrive items and populate the DB. Some items may be null and that's ok...

Is it possible with CF to connect to an SSH session? My main issue is invoking the private or public key loaded on the server. If it is possible please simply supply a reference for where I can find how to do it. I've checked google, keyword seach in TT and Ben Forta's Advanced CF App Dev...

Hi All, I've been checking LDAP and CFHTTP and trying to find a way to invode a client certificate to validate ourselves to a credit card processor. I've tried the LDAP but haven't a clue as to which action to use (query, add, etc). Using CFHTTP I get connection failed. If I hit the URL I...

Hi all, I have developed an application to generate emails for internal purposes. Part of the email requires reading a text file and pasting the contents into the email body. Where the problem is: We pull the text file from a specific directory on a network drive. I am trying to use <input...

In all my reading I haven't seen a way to execute a query without calling a page via a browser. I run some large queries often that sometimes take 30-45 minutes a piece. I've had to edit the registry on the machine I use as so the browser doesn't time out. Any way to execute a query (no results...

I've looked over the net and at several loan lenders sites to no avail. Anyone know of a Mortgage Rate API or better yet a custom CFX or &quot;Today's Interest Rates&quot;? Thanks! DeZiner Never be afraid to try something new. Remember that amateurs built the Ark. Professionals built the Titanic

Hi All. Searched the forum and google and couldn't come up with an answer. I want to take some dynamically displayed HTML code (or what the browser parses it out to) and turn it into an image for a preview. I have a fee based program that will create the needed HTML code for forms that users...

Hi All, I'm using: <cfloop index=&quot;fname&quot; list=&quot;#form.fieldnames#&quot;> #fname#: #Evaluate(&quot;form.&quot; & fname)#<br> </cfloop> As a simple form handler. What I am looking to do is to NOT SEND (print in email) those name/value pairs that don't have a value. I know fname...

My shopping cart returns a form field called status to me with a comma delim. value: <input type=&quot;hidden&quot; name=&quot;status&quot; value=&quot;275394,This transaction has been approved.,Y,404142852&quot;> Notice however the the &quot;Values&quot; are not in single or double quotes. I...

Any help is great help! I am a CF guy, and must create a php script that will loop thruough form fields and send the name value pair via email. Here is what I use in CF <cfloop index=&quot;fname&quot; list=&quot;#form.fieldnames#&quot;> #fname#: #Evaluate(&quot;form.&quot; & fname)#<br>...

After several complaints of errors from users I setup a page to track orders as they are made. I notice that seven out of 10 users seem to lose the sessionID after only 4 minutes or so and a new one is assigned. Rather than track by session ID I decided to use CreateUUID()as my unique...