Alpha DevCon 2018
Results 1 to 4 of 4

Thread: string scanner help

  1. #1
    Member
    Real Name
    Steven Greer
    Join Date
    Jun 2008
    Location
    Manchester,PA
    Posts
    374

    Default string scanner help

    I'm trying to escape a string that is a number encrypted with alpha and sent to sql. I can usually insert the data unless there is a ' or " in the encrypted string. I tested the query on mysql directly escaping the ' using \' but can't seem to figure out how to get string scanner to scan the string and escape and back chars.

  2. #2
    "Certified" Alphaholic G Gabriel's Avatar
    Real Name
    G. Gabriel
    Join Date
    Oct 2004
    Posts
    7,190

    Default Re: string scanner help

    You escape a backslash with a backslash. Sounds like you need regex instead of stringscanner.

  3. #3
    Member
    Real Name
    Steven Greer
    Join Date
    Jun 2008
    Location
    Manchester,PA
    Posts
    374

    Default Re: string scanner help

    i am taking cc numbers and encrypting them with alpha before they are sent to the sql server where they are encrypted again. I have the code to encrypt and decrypt working but when i tried to make changes from using variable to using table fields things got wacky. the old way would give it in "" but now i use what i think is the exact code and ir gives me the encrypted txt as &*&ndfg;'"$ with no quote wrap.

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    24,854

    Default Re: string scanner help

    Show us the code.
    There can be only one.

Similar Threads

  1. Finding variable string patterns in a longer string
    By Ted Giles in forum Alpha Five Version 11 - Desktop Applications
    Replies: 11
    Last Post: 06-06-2015, 03:01 AM
  2. Scanner Pen
    By forskare in forum Alpha Five Version 4
    Replies: 9
    Last Post: 08-19-2007, 05:05 PM
  3. use of scanner
    By Ruben Arredondo in forum Alpha Five Version 5
    Replies: 4
    Last Post: 05-13-2004, 04:37 AM
  4. New scanner installed
    By Lee Garrett in forum Alpha Five Versions 2 and 3
    Replies: 0
    Last Post: 04-26-2001, 09:05 PM
  5. reading from scanner
    By bobsk in forum Alpha Five Version 4
    Replies: 5
    Last Post: 05-05-2000, 04:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •