Search results for query: *

No, that will remove ALL 0's !!!

Sorry I didnt explain my last point... A connection object is like a physical connection to a database and so consumes precious system resources. If you are using one database, create only one connection to it, and leave the connection itself open intil you dont need the database anymore...

Must have been the asprin. :) Just noticed your early question on connections... Its up to you whether you do your connection setting in code or not. If you do you have more power at your fingertips, as ALL the properties, events and methods of the connection object are available...

Several things: 1. You have a typo in there "conbo5" should be "combo5" 2. You have an "End With" with out a "With" 3. The connection string should be "Data Source" not "datasource" 4. Yup sorry m8 use this instead, for the combo value...

If your combobox was named cboAgent then the following should return the value selected in a popup. msgbox cboAgent.ItemData(cboAgent.ListIndex) So use the following code: Dim straname As String straname = cboAgent.ItemData(cboAgent.ListIndex) Tracker("aname") = straname

Thanks for your help peter, however I am trying to code a solution in VB5 rather than do it manually in the database as the project is for technical staff with no database understanding (infact very little computer skills come to think of it). Just had a look at Access Replication and it seems...

Hi Peter, So you mean link the table to the remote odbc one? I need to create a local backup of the remote one. thnx

Just write "OPTION EXPLICIT" in the top of your code (in the General section. That way you will need to explicitly declare all variables u use. That way VB will helpfully prompt you if u dont declare or mistype any var names. You can probably set OPTION EXPLICIT as default...

I need to backup a table in a remote database (MySQL) onto a local one (in Access). Im using VB5, ADO and ODBC but cant fathom a decent solution without complex coding. Maybe... clone one recordset into another? Or... create a table replica? Thanks for your help folks. Will

Ok thanx Jon, Tacey & Don, I seem to be having initial success with my PerlScript in ASP so im not going to tease the tiger by installing other stuff. Will

hate to pull this out the bag again, but can anyone suggest a sollution to this '500 server error' when running .pl files from the browser with PWS and ActivePerl on Win98 ??? Thnx folks, Will ps. TechDude - renaming .pl -> .cgi dosent wrk. perl works fine in dos tho...hmmmmm

Hi Rajesh, Install ActiveState's Active Perl from www.activestate.com It will let you use PerlScript in your ASP pages and should let u use .pl files. I have installed it and can use PerlScript in asp aswell as execute my .pl files from dos window or explorer. But cant seem to get it to...

Whoa...Sounds H E A V Y

erm where's the API viewer and what is the FAQ # please? Ive used the PPM and have read the ActivePerl documentation, there isnt an API viewer. Do you mean the OLE browser? There are some lwp bat files in the C:\Perl\bin directory. And there is also an lwp directory in C:\Perl\site\lib\LWP...

Hi there, i'm a noobie to Perl and therfore need help. I have installed PWS and ActiveState's ActivePerl 5.6 on my Win98 PC. I need a little guidance on when to use Perl / PerlScript. And whether to do this in ASP or in PL files? ------------------------------------------- Im trying to get...

Can someone point me to where I can download Perl for Win98SE's PWS? I hear its just a case of popping the files in a directory, fidling with a RegEdit key and creating file assosiations to .pl files in Windows. Any advice out there? And is installing modules easy? Need to install the libwww...

Hi Chad, Can you elaborate please? Will ps. yea it would be nice to see the response (which is a string of plain text).

The module isnt installed on the remote server. Im going to try it locally. Where can I get it from ? Can it be run on PWS ? Thanks Tracy

HTTP_ACCEPT_LANGUAGE is the browser language not server. If you have IE, go to: Tools->Internet Options->Languages If you change this value, then the server should pick it up under HTTP_ACCEPT_LANGUAGE. Therefore a look at this server variable will tell you what the browser language and...

The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are: Can't locate object method "new" via package "http::Request" at d:\inetpub\fp04-144\test\tracy.pl line 15. Thats this line... my $req = new...