Recent content by chandler

I'm writing a routine to upload a .dbf table to a mySql table. Using some code I found on these forums, I'm able to generate a .sql script. What I'm stuck on is executing the .sql script in foxpro. The issue is that I can't get multiple commands to execute from a single script. Only a single...

I have a similar data layout for some of our shop operations. I basically created a view in the cross-tab looking format and then query that with a web service for my client app. However, how do I go about updating the events? In my client app each "record" has a field for every event and I...

I've got a .lbx pulling in data to print out to a sheet of 2 columns of 2"x4" labels. Everything works great, but I'd like to have the ability to skip labels in order to avoid wasting labels and having to use a new sheet of labels every time. The only way I can think of right now is to insert...

Actually, it looks like the search function isn't working period. Chandler I ran over my dogma with karma!

When I search for "Excel" or "excel" I get no returns. Yet I know they're in here! What's up with that? Chandler I ran over my dogma with karma!

Worked like a charm. Muchas Gracias. Chandler I ran over my dogma with karma!

I've been looking for a way to name the workbooks and worksheets I create using VFP 9.0 So far I've found ways to create and select, but not to name. Any help is much appreciated. Chandler I ran over my dogma with karma!

FSEEK( _splits, 0, 2) That's it. Thanks. Chandler I ran over my dogma with karma!

I'm using the fputs() function to send text to a text file, but the beginning of each line in the text file is showing 2 squares for some control characters. Am I missing a parameter? FSEEK(_splits,2,2) fputs(_splits,ALLTRIM(pname)) Chandler I ran over my dogma with karma!

Thanks everyone. I'm going to end up putting the header in a text file because that takes care of making the change in quite a few other processes all over the department. Chandler I ran over my dogma with karma!

I'm trying to create a header row for a comma delimited file using STRTOFILE(), but the variable for the cExpression property is greater than 255 characters. Is there a workaround? && Header Row hdr='"FIRST","LAST","OR CURRENT RESIDENT","STREET","CITY","ST","ZIP4","JOBNUM","PART","OPT...

I've got a routine that computes the mean and standard deviations from an array ($closeData). However, I'd like the routine to skip the the first 97 records. Here is my code that can process the entire array: #Function for calculating Standard Deviation function standard_deviation($std)...

Hmm.... well, I understand that it is left to the discretion of the browser and that's acceptable to me at this time. I have another method to "secure" content using the Joomla session variables. But having 2 methods can't hurt either. Using just the standard <a href="url link"...

I'm trying to create a new window with window.open, but I need to pass the referrer info so that the request doesn't get "locked out" by my .htaccess file. Is there a way in php to pass that info? Chandler I ran over my dogma with karma!

Thanks Rob. That'll do nicely. Muchas Gracias. Chandler I ran over my dogma with karma!