This topic is locked

Searching problem

1/18/2005 12:41:06 PM
ASPRunnerPro General questions
N
netquest author

My database table has varchar and money fields. When we do any searches we get the following error. I need the ability to search either by description or money if possible. I'm using the demo and it's about expired, so I need to see if this can be resolved before we purchase it. Other than that this is an awsome kick ass program!
Here's the error: <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1032&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />

Error 2147217900: Implicit conversion from data type money to varchar is not allowed. Use the CONVERT function to run this query.

Sergey Kornilov admin 1/24/2005

please try the latest update which should have fixed issue with search for MONEY datatype: http://www.asprunner.com/files/asprunnerpro31a.exe