Search results for query: *

I have successfully made a recordset object full of data from a parameterized SQL Server stored procedure. Now I would like to quickly zap the resulting recordset object into an Access Table so I can use it as the source for an append query. I would like to avoid looping through the recordset...

I have the following code snippet that sets a date range parameter incorrectly. (The CR examples do not go this deep. I've looked.) I get no errors, but if I use a Selection Formula of {TimeSheet.Work_Date} in {?Date Range} then it filters out all the records. If I remove the selection...

I need to know what techniques to use when programming an ADP so that there is no locking of the database going on except for brief intervals. I would like to use optimistic locking, locking records only when I call the Update method. ADO Calls this adLockOptimistic. ~ Shaun Take care...

I'm not a UNIX guy, but I need to tell UNIX to search for all files in recursive subdirectories that are named YYMMDD.Z where YYMMDD is yesterday's date. So far, I've computed yesterday's date with this: # Yesterday.AWK BEGIN { printf "Yesterday's filename is...

Q1: Where can I find a web-based AWK reference manual so I don't have to hound this forum with dumb questions? Q2: How do I represent a null (ASCII=0) in a regexp? Q3: The new version of my input file contains a field of 356 NULLs separating each report, (multiple reports per file) yet the...

I have 146 reports to go through and document. Without purchasing a product, I would like to construct a loop in VB code that opens up each RPT filename contained in a table, and using the Crystal Reports 8.5 object model, tells me what the Table Name(s) are in the Set Location dialog. This...

Has anyone written an AWK to analyze the IIS log files that look like the example below? I wish to gather statistics about how often people are logging in to a DEFAULT.ASP, grouped by IP address. Thanks! #Software: Microsoft Internet Information Server 4.0 #Version: 1.0 #Date: 2001-07-17...

Hey, this used to work, but when I execute Response.Redirect "url" in my ASP page, I am getting the following error: Response object error 'ASP 0156 : 80004005' The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing...

How do I animate an animated GIF on an Access 2002 form? --Shaun Merrill

Environment: SQL Server 7, MS Access XP Data Access Pages Background: I have a main DAP page with a command button on it that brings up a popup form. The popup form is bound to child records, i.e. records that are on the Many-side of the relationship with the main. Request: My user would like...

Crystal Developers: Here is the code I ended up with after messing around with the PDF paradigm for about a week. I post it here to request for comments to improve it and make it more bullet-proof, so [machinegun] please give me both barrels! My intent is to simply create a PDF and display...

I have an ASP page that contains an ActiveX CRViewer component version 8.5.0.67. When the user presses the Export button on the viewer, a message box shows: "This report cannot be exported." The user usually wants to export to PDF. Is it possible to get this button working...

I know some of you are dead-set against cursors, so please see if you can help me with this one. (It is not homework.) I have a very large table (730,000 rows). I need to determine if an integer in one field of the composite key in that table is consecutive for 10 rows, 100 rows, or 1000...

I hope this is concise enough. I stripped out a lot of flack. This is probably a common telecomm problem. PROBLEM: The following script processes the first field of a line and skips the rest of the fields in the line. If I replace the red line of code with a print statement, it acts...

How do I print an integer with leading zeros, i.e. the value 6 printed as 0006 and the value 15 printed as 0015?

I would like to convert each line R,34343,23,3,"3,4", R,34343,23,4,"3,4", R,34343,23,3,"4,3", to 1,R,34343,23,3,"3,4", 2,R,34343,23,4,"3,4", 3,R,34343,23,3,"4,3", I'm a NOOB with AWK. Thanks!

My XSL output is in unicode. I would like it to be plain text. Furthermore, it is going to a UNIX machine, so the <CR><LF> at the end of each line will need to be changed to a <CR> I believe. Can anyone help with either issue? Here is the header of my XSL file: <?xml...

I would like to translate a tab-delimited file into XML using XSL. I would like to prepend and append an XML wrapper to it, then use string functions to parse it. However, I'm not skilled in this, and have wasted much time. The notation &quot;tab&quot; means that there is a tab character in...

I am translating XML to XML with XSLT. I would like the resulting XML to contain a reference (validate) to a specific schema. I am trying to get the root element of the result tree to contain xsi:noNamespaceSchemaLocation=&quot;yadda.xsd&quot; as an attribute to the root element. But I am...

How do I create an element with required content? That is, <root> <item> <RequiredField></RequiredField> <Name>A</Name> </item> <item> <RequiredField>Value</RequiredField> <Name>B</Name> </item> </root> I want this to not validate, because the first item did not have any...