Search results for query: *

Hi Tek, Thanks for the reply. I am using CF5 and that is what my website is hosted with also. I tried the connection string you suggested and it still give and error. My code is: <CFQUERY NAME=&quot;player&quot; dbtype=&quot;dynamic&quot; connectstring=&quot;DRIVER={Microsoft Paradox Driver...

Hi, I can not get the syntax correct to establish a dsnless connection to Paradox tables. The string given to me by the web host is: &quot;DRIVER={Microsoft Paradox Driver (*.db)}; DBQ=c:\data\database\&quot; But it doesn't work. I want to use it with a query but when I do as such it fails...

Thanks Tek, I guess a session variable is probably the way to go. So what I would do is assign the id to a session variable at login and then on subsequent pages compare the session id to the id passed in the url to be sure they're the same. Makes sense. thanks again. Regards, Roy F.

Thanks Tek, &quot;Actually, a DSNless connection might be faster when you are solely working with a database, but add users and a DSN is mandatory, since a DSNless connection will not bear hardly any load at all.&quot; The site is for internal use only, and the max total users will be around...

Hi, I am passing a variable to a form through a url that contains an id variable and CF session variables. This works fine but anyone can just the change the variable in the url and see someone elses data. So if the original url is: main.cfm?id=36 someone can just change it to main.cfm?id=20...

Hi All, I just signed up with a CF host that allows me to use Paradox tables (my preferred database format), only through a DSNless connection. I currently have CF4 on my computer to develop with, but I understand that only CF5 supports DSNless connections, not CF4 or MX. I can't find a version...

Hi John, Thanks a lot for the help. I actually came across an answer to this problem that I don't really understand but it works very well. It was given to me by Dan Dohan on one of the ColdFusion newsgroups and solves this problem. I thought I'd share it here for anyone else interested in using...

Hi All, I'm having a rather perplexing problem and I hope someone can point me in the direction of a solution. I have a table that stores GroupID's and Activity Numbers. Each GroupID can have multiple Activity Numbers such as: GroupID ActivityNumber 1 2 1...

Hi Kimberly, When passing numbers to a query as a list you don't need single quotes but when passing string values you do. In order to get the result you want you need to use the following syntax: WHERE City IN (#PreserveSingleQuotes(locations)#) Be sure the data from the multiselect list has...

Thanks Marcelo, I'll give that a try also. Regards, Roy F.

Hi Kevin, Thanks again for the response. The solution that I have found so far is to have the Log Out button go to a blank page that contains the following code in the body tag: onload=&quot;location.href='logout_page_users_see.cfm';&quot; Then if anyone hits the back button it take them back...

Hi Kevin, Thanks for the reply. I don't really want to disable the back button on the browser. I agree with you whole heartily that you don't want to take away the softwares functionality. I only want to prevent the back button from allowing reentry into the site after the user logs out. The...

Hi Everyone, I added security to my web pages by using a login screen and setting session variables. I am not using cookies. Everything is working fine with one exception. I want the users to be able to use the back and forward buttons on the browser once they are logged into the site. After...