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 Rhinorhino 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: ynott
  • Order by date
  1. ynott

    if then for special characters in Select Statement

    Here's the last part of a Select statement after the LIKE portion: SQL = SQL & "' & A1 & A2 & A3 & A4 & A5 & A6 & A7 &"'" A1 to A7 will analysis each character in the 7 character querystring. I'm using a hyphen in the query to indicate if user wants a wildcard in this position. Ex...
  2. ynott

    Wildcard searchs in ASP SQL Statement?

    Here's the last part of a SQL statement after the LIKE portion: SQL1 = SQL1 & "' & A1 & A2 & A3 & A4 & A5 & A6 & A7 &"'" This will take all 7 letters/numbers with success. However, I'm trying to create a wildcard in each of the 7 spots if it's called for. Ex, *ABC*23, or 1ABC12*, etc. Since...
  3. ynott

    Wildcard searchs in ASP SQL Statement?

    I have a field in the database that supports up to 8 characters. I would like to use * as a wildcard type and ? as a wildcard type. So, if I used 4AWL* and 4AWL??99, the * is for anything after and the ?? is just for characters 5 and 6 in that field. So, for me, building this type of SQL...
  4. ynott

    Select Statement help

    Perfect. Thanks
  5. ynott

    Select Statement help

    The following select statement works and I'm using the % because this number has a hyphen and any two numbers after that that I need, for example 00010044-01: SQL6 = "SELECT NO, LNAME, FNAME, MNAME, DOB" SQL6 = SQL6 & " from COMP9.DBO.proc2" SQL6 = SQL6 & " Where NO like '00010044%'" set rs6...
  6. ynott

    Getting 'like' behavior in Select Match/Against

    string value in Select statement? DIM EntryNo is set EntryNo = "" This first select statement against a SQL DB works: SQL6 = "SELECT NO, LNAME, FNAME, MNAME, DOB" SQL6 = SQL6 & " from COMP9.DBO.proc" SQL6 = SQL6 & " Where NO like '00010044%'" set rs6 = my_conn.Execute(SQL6) However, this is...
  7. ynott

    hyperlink ? for subreport

    So, when I enter the full website of http://Server/finance/costreport.htm for a link I'm successful. However, the main report that i'm running is within the same folder that this link is on. Since this report goes to several Crystal servers, I would like to just say /costreport.htm or...
  8. ynott

    MSCAL (Calendar Control) causing a run-time error?

    I have a VB program that I made several years ago and it's not working on my new computer. I'm running VB 6.0 and I thinked I've narrowed down the problem. When I run the program, I trapped the problem to a particular line. Here's the error message: Run-time error '-2147417848 (80010108)'...
  9. ynott

    Pulling a date from a two digit year and julian date

    I think this is the answer for those that are interested. In the future, maybe I'll notice an error, but so far it's working. CreateDate: DateSerial((2000+CLng(Left([EventNumber],2))),1,CLng(Mid([EventNumber],4,3)))
  10. ynott

    Pulling a date from a two digit year and julian date

    001 represents January 1st in the event number if that helps clear it up.
  11. ynott

    Pulling a date from a two digit year and julian date

    I have a field with an event number. Example, 06-001-019. 06 is for the year, 001 is the julian date, and 019 for the event of the day. My goal is to create a query that will display the date of the event automatically. Any ideas? TIA
  12. ynott

    How to list an employee name with 0 as a total

    Thanks, but how do I narrow down the Sales.date between two dates then?
  13. ynott

    How to list an employee name with 0 as a total

    Unfortunately, I simplied what I'm doing. The report is much more complicated than just what I'm showing. I using the charts within Crystal to also perform division break-downs. If it can be done it Crystal, I'm hoping to do that. Thanks for the idea though.
  14. ynott

    How to list an employee name with 0 as a total

    I'll make this simple. I have an Access Database that list's every employee's number (Personnel.EmpNo) I link the Access document to an Oracle DB via Personnel.EmpNo <-> Sales.Emp_No In that same Sales table, there is a field called Sales.Ticket, which is a unique number. Then, I do a count...
  15. ynott

    Linking problem with two tables

    Convert null values did it. THANKS!
  16. ynott

    Linking problem with two tables

    Sorry about that. Yes, left join with: Left outer join to Business.ID <-> Comment.ReferenceID No other selection criteria and no results. isnull({Comment.ReferenceID}) is in the selection criteria
  17. ynott

    Linking problem with two tables

    lbass, thanks for taking a shot, but that didn't work. I know it's probably something simple that's escaping me.
  18. ynott

    Linking problem with two tables

    How to see all business names? Table 1 Business.ID Business.Name Table 2 Comment.ID Comment.ReferenceID Comment.Comment Left outer join to Business.ID <-> Comment.ReferenceID Now, if I list all Business.Name, I will see all Business names. For the most part, every Business.Name will have...
  19. ynott

    How to identify a business without a particular line

    I'll simplify to the following: table1.BusinessName table1.ID tableA.RefID tableA.comment tableA has a many to one relation. table1.ID <-> tableA.RefId Now the question. #1 - I would like to identify every table1.BusinessName that doesn't have at least one tableA.comment that DOES NOT have...
  20. ynott

    Crystal 8 - How to grab last 5 returns based on descending date

    I have 40 vehicles within a field called Log.VehName. I have another field called Log.Date_Time. The third field is called Log.Mileage. My goal is to create a report with Log.VehName as the group and to only see the last 5 reported mileages.

Part and Inventory Search

Back
Top