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!

Register Log in
  • Congratulations Wanet Telecoms Ltd 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: *

  • Users: johnnyi80
  • Content: Threads
  • Order by date
  1. johnnyi80

    Number formats in SQL statements

    I am trying to update/insert records in a DB, using SQL statements. All numeric formats seem to work fine except for the Scientific (exponential) notations. In an UPDATE statement it raises "type mismatch" error (Example1). I managed to go arround it by using casting (Example2). When using...
  2. johnnyi80

    Passing parameters to an SQL query

    Can any one help me out with my problem please? I am trying to run an SQL query1, which has an INNER JOIN in its FROM statement to another SQL query2. Query2 is using a parameter in its WHERE clause for filtering. When I run Query1 and error comes up: "Parameter not set in query string" I...

Part and Inventory Search

Back
Top