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

    using .execute to run SQL in a recordset

    I am retrieving a recordset that contains one field and between 10 and 20 records depending on criteria. The field that I'm retrieving is an SQL statement. I'm trying to loop through the records and execute each statement, which works if there are no variables in the statement. Here's where...
  2. pyroskliq

    status code 200 on http "CONNECT" attempts

    I've been looking for a couple of days on various forums, and can't find a real answer to my question. Has anybod seen this behavior? I'm running apache 1.3.27 on FreeBSD 5.0 w/ mod_php4, mod_gzip, and mod_perl. I've had this running in it's current configuration for quite some time...
  3. pyroskliq

    Storing and retrieving file paths

    I am working on a database with some export/import functions. I need to be able to have the user specify the export/import directory once, and store this information in a table, then each function needs to retrieve those paths from the table each time they run. I've searched all over for code...
  4. pyroskliq

    Me.requery - how do I stay with the current record?

    I have a form "Updates" with 4 text box controls that are bound to fields in the table "Names" (fields are "FName", "LName", "DOB", and "Gender".) There are 4 more unbound text boxes where the user can enter a new "FName&quot...
  5. pyroskliq

    Format cell color based on <td> contents

    Is it possible to format the color of a specific cell based on the contents of the cell? I have an .asp page that displays the results of a query. My "status" field can return a value of "PROD", "REJECT", or "HOLD". What I'm attempting to do is to...
  6. pyroskliq

    Applying a filter to a subquery on a form

    I have a form ("ASM") with a subform that contains a query ("Pricing"). I am trying to place a checkbox ("current") on the form so that when "current" = true, then the filter "currentPricing" will be applied to the query "Pricing" on...
  7. pyroskliq

    Using a check box to determine query criteria

    I have created a form containing a subreport that lists records with the fields vendor number, beginning date, and ending date. Some of the records do not have an ending date. My current query returns all records by vendor number. What I'm attempting to do is place a check box on the form...
  8. pyroskliq

    !--#exec cgi -- producing a weird header

    When I call my poll using <!--#exec cgi = &quot;xxxxx.cgi&quot;--> I get this above the poll... HTTP/1.1 200 OK Date: Tue, 12 Jun 2001 23:28:21 GMT Server: Microsoft-IIS/5.0 Content-type: text/html I've just moved to IIS from another webserver, and can't find any documentation on why or how...
  9. pyroskliq

    Problem with sorting windows explorer views

    I'm using Windows 98SE... I have somehow managed to change the default view of my explorer windows to sort in reverse aphabetical order rather than the normal way. I've got no clue how it got this way, and no clue how to get it back to the original way. Under the 'view' tab in the 'folder...
  10. pyroskliq

    Complex Win2Kpro/Linux Mandrake dual boot

    I'm looking for a way to accomplish this without having to redo my Win2k installation...anybody tried this: I have three physical drives: 15 gig on ide0 and two 30 gigs that are striped on a raid controller. The 15 has win98 on it, and this drive is called &quot;c:&quot; by both win98 and...
  11. pyroskliq

    Creating a join on a portion of a text field?

    I have a field that I need to create a join on that is (a string) 16 characters long. I only want to join on the first 15 characters in the string. I've used MS Foxpro (sparingly) and have seen joins like this. Is this possible with Access? Or do I need to create a function to 'extract' the...
  12. pyroskliq

    Defining what is or what isn't a 'duplicate' record

    I have a duplicate query that produces sets of records that are duplicates based on 6 different fields. My problem is that there is a seventh field that I need to use to limit some of the dups. This seventh field is a record identifier that is unique to the record. This field is not...
  13. pyroskliq

    Need help with VB script for SQL server

    My VB scripting isn't too good, and I'm trying to create a script for a data transformation in SQL server. The field that I'm transforming contains a combination of number and text. All are 4 characters long, such as 1000, 1100, 5000 etc. Some are 19XX or 11DX. The script I am trying to...
  14. pyroskliq

    How do I limit the records this duplicate rpt returns?

    I have a table with around 1 million records that is replaced each week (instead of appended to) by a new table with about 45,000 new records. All records are date stamped (so I am able to tell when the records were added to the table). I am trying to create a query that will return to me...

Part and Inventory Search

Back
Top