Textbox Question


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Textbox Question

  1. #1
    Join Date
    Apr 2004
    Posts
    23

    Textbox Question

    I have a text box in ASP.NET 2.0 that the user is entering search strings in. The search strings are numbers but they need to have the wildcard ablility.

    I take in the text pass it to a stored procedure that does a like to it....

    So the user enters %23 to get all the items ending in 23 and ASP sends a # to the procedure.

    How do I stop this from happening?

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    How is the data stored in the database? You cannot use wildcards with numeric data, only text. To find numeric values ending in 23, try this:

    SELECT columns FROM table
    WHERE numericColumn % 100 = 23
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. Replies: 2
    Last Post: 12-12-2007, 10:03 AM
  2. Replies: 1
    Last Post: 07-07-2006, 06:37 AM
  3. Quick Stupid VB Question
    By GRapoza in forum VB Classic
    Replies: 2
    Last Post: 03-30-2006, 04:14 PM
  4. Appending To TextBox, Unique Question?
    By RPBLEA in forum Java
    Replies: 4
    Last Post: 04-27-2005, 09:20 AM
  5. Replies: 0
    Last Post: 11-02-2000, 09:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center