ASP Search MS SQL Float

Expand Post »

Yesterday I converted my site over to MS SQL and now I'm having an issue with part of my site. The search box is supposed to check for a part number the user types in, but it doesn't even come close anymore. In Access the column searched was a Number col. Now the column is a Float. The sql line is:

ASP Syntax (Toggle Plain Text)

 sql = select * FROM brandList WHERE partno LIKE '%%" & part_no &"'"

This was working in Access with out trouble.

Thanks

Similar Threads

search sql database textbox.text in ASP.NET
Full-Text Search (SQL Server 2008) in MS SQL
Web.config error in ASP.NET with SQL Server 2005 in ASP.NET

hatrickwah

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

11 posts
since Jul 2010

Permalink

Jul 19th, 2010

Re: ASP Search MS SQL Float

Ignore, I found the answer on MSDN. Floats are no good for SQL statements involving LIKE or = . In this case, I changed the type over to Numeric and now it works fine.

hatrickwah

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

11 posts
since Jul 2010

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP Forum Timeline: ASP Join Problem?

Next Thread in ASP Forum Timeline: Help with Flash

DaniWeb Message

Cancel Changes

User Name
Password