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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jesse1

    Flash games for Droid

    I am trying to export flash games and install them on android based phones. Can anyone recommend any books or online resources? thanks
  2. jesse1

    IE8 setting cookies

    IE8 does not like the first line in the if statement: <cfcookie name = "sp" > I must left it their by mistake but it only causes problems in IE8 The following code works fine. <cfoutput> <cfif url.sprok eq 2> <cfcookie name = "sp" value = "#url.sprok#" expires = "never"...
  3. jesse1

    IE8 setting cookies

    The following code works in IE7 and down but fails to set a cookie in IE8. Is anyone familiar with this problem. <cfoutput> <cfif url.sprok eq 2> <cfcookie name = "sp" > <cfcookie name = "sp" value = "#url.sprok#" expires = "never" > <cfelse> <cfcookie...
  4. jesse1

    htaccess + masking + CGI.SERVER_NAME

    I am using the following code to redirect to a subdomain: <cfset request.UrlStr = "http://"&#CGI.SERVER_NAME#&#CGI.PATH_INFO#> <cfif CGI.SERVER_NAME EQ 'www.demo.mydomain.com' or CGI.SERVER_NAME EQ 'demo.mydomain.com'> <cflocation url="http://www.mydomain.com/demo"></cfif> This works but...
  5. jesse1

    htaccess and masking

    I am using cgiServer_name to read the url and forward to the correct folder. But I want to mask the url. For example I have a sub domain "demo.mydomain.com" that points to mydomain.com/demo. It works but the url reads mydomain.com/demo, I want it to read demo.mydomain.com I was told to use...
  6. jesse1

    inserting date string into a smalldatetime

    One of the fields in a csv file is date of birth. The dates is retrieved correctly but Iget the followng error when trying to insert it, Error: Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting character string to smalldatetime data type. INSERT INTO...
  7. jesse1

    duplicating tables

    you have to copy and paste. Clicking ignores the hyphen at the end
  8. jesse1

    duplicating tables

    George, Thanks so much for the help. My last question is how many records can I put in a table before things start to slow down. My concern is with two tables, the first has 9 int fields, 6 nvarchar fields, and a date field. The second has 6 text fields and 2 int fields
  9. jesse1

    duplicating tables

    George, I guess the problem lies in my lack of database knowledge. The original database was set up how you are suggesting. I decided to separate the tables (per client) because I feared data corruption with multiple clients hitting the same tables at the same time. I also wondered if the...
  10. jesse1

    duplicating tables

    It works. but should I be worried about violating normalization rules?
  11. jesse1

    duplicating tables

    I created a script with the above code. When I run the script it creates the "DulicateTables" procedure. How do I run the run that procedure? If I try to excute the script again it just says the "DulicateTables" procedure already exists.
  12. jesse1

    duplicating tables

    I am a Coldfusion programer that uses SQL 2008 as a backend but am not proficient sql. I would like to write a script that I can use to duplicate tables. For example, I have table1Dem, table2Dem and table3Dem. I would like to duplicate table1Dem and table2Dem w/o carrying the data over...
  13. jesse1

    reReplace

    I am uploading a csv file and want to limit the fields to letter numbers and spaces. I am using the listfix function to replace empty csv fields with Null. The code below does not seem to work because it does not remove ,'s and .'s <cfset newI = #listgetAt('#index#',1, ',')#> <cfif newI neq...
  14. jesse1

    cfheader and cookies good idea????

    I have a site in spanish and english. I have the user click the Spanish if they want the Spanish version. I use the following code to set a cookie: <cfheader name="Set-Cookie" value="lang=#url.l# ; expires=NEVER"> I use cfif tags on all the pages to show the spanish version: <cfif...
  15. jesse1

    Problem with client login- Session ending early

    I am using the following code to allow users to login to a site. Some users have been getting bumped. Is there a problem with the way I set up my session variables? Do I need to make the variables more specific to a client? If so how? <!--- Get user's details from the database --->...
  16. jesse1

    Sanitizing user input

    Is there a way to modify this to also allow only the following wo characters: "@" and "." <cfset thecomments =REReplaceNoCase (form.comments, '[^a-z0-9]', '', 'all')>
  17. jesse1

    Sanitizing user input

    Would this be the safest way to solve the problem. Below is the SaveSQL script from CFLIB.com. <cfset myUsername = sqlSafe(form.username)> <cfset finalUsername = <cfqueryparam value="#myUsername#" cfsqltype="cf_sql_varchar"> Example: <cfset username = sqlSafe(form.username)> Parameters...
  18. jesse1

    Sanitizing user input

    I checked out cflib.com, recommended by cfsearching and found the follwoing. It protects against HTMl, Scripts and Applets. But will it help against SQL injections? Description: Strips out nasty HTML/scripting but leaves friendly HTML formatting in place. This tag is useful for processing...
  19. jesse1

    Sanitizing user input

    i want to keep my users from entering harmful html or sql code. I thought of use one of the two solutions. I just want to know If these are efficient answers. The first one would have to be expanded but the concept is there. <cfset thecomments = #Replacelist(form.comments, "<, >", "&lt...
  20. jesse1

    convert date to string

    Nevermind '#dateformat(now(), 'mm/dd/yyyy')#'

Part and Inventory Search

Back
Top