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 derfloh 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: mfenn
  • Content: Threads
  • Order by date
  1. mfenn

    multiple wildcards in WHERE statement

    Hello, I'm using classic asp with a text (flat file) database that doesnt like searches using "like" or left(field,N) so I'm trying wildcards. I'm looking to see if a person exists in our database already and trying to account for typo's. The search is looking for partials on first and last...
  2. mfenn

    find file using wildcard

    Hello, Not sure if I have the correct forum for this. We have a website where outside customers fill out a form that gets submitted to a SQL database, they can attach pdf or txt files to the data they are submitting. The attachments are stored in a folder on the webserver. Each submission...
  3. mfenn

    flat file matching partial field variable

    Hello, Our live database is actually flat files (.dbf). We use SQL Server 2000 DTS packages to copy data from the flat files into SQL tables every night. All of our reports are based on these SQL tables instead of the live data. We are changing one of our asp pages to use the live database...
  4. mfenn

    ASP type mismatch with a date

    Hello all, Im pulling a date out of SQL Server that is 04141991 format and i need to change it to 19910414. I'm pretty new to ASP and I inherited this app from the previous IT person. strSql= " Select * from enrolldep where enrollid = '" & strEnrollID & "'" Set rst2 = dbConn.execute(strSql...
  5. mfenn

    display total from subreport

    Hello, Im using CR 8.5 with ODBC connection to tables. I need to pull a total from the subreport into the footer of the main report. The subreport will display the correct amount when run by itself but displays 0.00 in the main report. I have tried just putting the subreport in the main...
  6. mfenn

    Total with concatenated details

    Hi there, I found a post to tell me out to concatenate message code fields, which works great. But now I am having a problem with summary totals for detail lines that have more than 1 message code on a line. If the line does not have a message or only has 1 message the total is fine, but the...

Part and Inventory Search

Back
Top