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!

  • Congratulations SkipVought 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: *

  1. chidori

    Data type mismatch using sql

    Hi, When I want to compare a field to a number I get an error saying there is a datatype missmatch. I think the problem is that the MS-Access field that I am comparing to is a number field instead of a text field. So how can I get around this? The code I used is: SELECT pd_svgrp, pd_active...
  2. chidori

    Integrating MySQL Access and coldfusion

    Hi, I've developed several coldfusion pages so far using Access. However because of size limitations I have decided to migrate to MYSQL. I am a little confused about how everything works now. When I write SQL in the coldfusion webpages to search the access database, is Access actually doing...
  3. chidori

    Getting Started with MYSQL on Windows 2000

    Hi, I've spent the past 2 hrs looking up online help documents but none of them seem to describe how I can get mysql server started. They start off with a bunch of command line arguments that are not meant for windows. I am very experienced with using Access and SQL. All I want to try to do is...
  4. chidori

    What is the best database to use for 1 million+ records?

    Hi, I am working for a company that needs to search through millions of records, that span several years. Currently we are using MS Access, but we have pretty much reached the limit, where we are forced to make a seperate database for each month. I need to find an affordable/free yet stable...
  5. chidori

    cfcontent file/mime SAVE AS filename problem

    Hi, I am trying to make a coldfusion page return a file to a user whenever the user clicks on the link, but whenever the SAVE AS dialouge box opens the default "save as" name is the same name as the webpage and not the name of the actual file it is saving. For example: in my...
  6. chidori

    comparing two text field values boolean

    Thank you! Ah, I totally forgot Cold fusion uses different operators, I was trying to use <CFIF &quot;X < Y&quot;> ... I feel so silly... hahaha thanks, Chi
  7. chidori

    comparing two text field values boolean

    Hi, This is probably a simple question but somehow I can't get it to work. What is the simplest way to compare two numbers from two different text boxes? I want to set up a field that asks for a range of numbers but I need to make sure the first number is always smaller than the second number...

Part and Inventory Search

Back
Top