Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
'OR' overriding 'AND'
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... -
DIS-Allow Multiple Logins, same username / Password
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... -
Searching data that has an apostrophe
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... -
Limited number of addresses to forward to???
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...- DeZiner
- Thread
- Replies: 1
- Forum: - General Groupware/Mail server discussion
-
SSH CFEXECUTE calling ssh program
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... -
Compare() not working as expected
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... -
cfapplication caching
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="Expires"... -
While loop returning records 2 and higher. Where's the first?
while ($myrow = mysql_fetch_array($result)) { printf ("<a href='calldetail.php?id=%s' target='_blank'>%s</a> <br>", $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... -
Image Rollover, Change HREF too
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...- DeZiner
- Thread
- Replies: 7
- Forum: Javascript
-
ListLen Null Entries
I have set: <cfset MyList = ",,,,,"> Then use: listlen(MyList, ",") 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... -
SSH (not FTP) with CF
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... -
Invoke certificate to create SSL connection
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... -
<cffile> when form field is hidden
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... -
Run CF Page not browser dependent
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... -
Mortgage Interest Rate API
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 "Today's Interest Rates"? Thanks! DeZiner Never be afraid to try something new. Remember that amateurs built the Ark. Professionals built the Titanic -
Text to image dynamically
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... -
Loop form fields for email / Don't send NULL
Hi All, I'm using: <cfloop index="fname" list="#form.fieldnames#"> #fname#: #Evaluate("form." & 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... -
Read 2nd part: comma delim. form value
My shopping cart returns a form field called status to me with a comma delim. value: <input type="hidden" name="status" value="275394,This transaction has been approved.,Y,404142852"> Notice however the the "Values" are not in single or double quotes. I... -
Need to loop thru form responses and email
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="fname" list="#form.fieldnames#"> #fname#: #Evaluate("form." & fname)#<br>... -
Keep loosing sessionID in under 4 minutes
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...
