Recent content by moroeh

Hi tlbroadbent: Sorry I didn't answer before but I have been sick during the weekend and monday (nice way to spend weekend I guess) and until today I couldn't see your answer. I have to say I have the same question you have. Why the DBA doesn't allow me to do the job. But there is no other way...

Hi: By "I have no permissions in the server?" I mean that I don't have permissions for doing scheduled jobs (for all the other things I do have permissions!), and the problem is that I don't know how to schedule a job (an stored procedure, an asp, a vbscript or whatever) to be able to...

Hi: Thanks for your help, but I still have the same problem. I have no permissions in the server. I need to do someway I can execute the script on scheduled times (on the server itself).

Hello: I need to do a scheduled job that must run every day at 0:00. I tried to do it with SQL SERVER enterprise manager, but the server we have is shared with some other clients and the server Admin told me we have no permits to do scheduled jobs (because of security problems). The question...

Tarwn: But, how do you block the specific table while you do the insert and get the @@IDENTITY? I have just found a thread where they state that << the @@IDENTITY returns the last identity value on the same open connection to the database >> Can it interfiere with other users that are working...

Hi: I want to insert into a field in a table the value of the primary key of other table. This is a 1 to N relationship and I need to make the INSERT INTO of both tables. I have been looking in other threads, and I have found the next sentence: Set recordset = connection.Execute(&quot;select...

Actually, the array is supposed to be populated with dates. And I think I was trying to write it in the screen.... It works (I just made another trying)!!! Thanks to all! By the way, is there any webpage to know all this functions in VBscript (kind of glossary of functions)? Thanks again...

Don´t worry people. But still have a problem (sorry about this ) I know your ego is gonna get hurt (or mine, if the problem results to be that I have no idea of making ASP's). When I try to use the functions you say (join and split) I get the next error (I will try to translate because is...

Hi: I guess somebody already answered this, but I am not able to find any answer. Does anybody know how to send an array in VBScript with the post method? I have been trying to send it with <input name=&quot;MyArray&quot; type=&quot;hidden&quot; value=&quot;<%=MyArray%>&quot;> <input...

Hi again: Thanks, but what I really need is some help (maybe a link or a howto... I don't know for sure) about how to use transactions and querydefs (I believe this is the only way for using transactions). I'm been reading my post again and I realize there is almost no way to understand what I...

Hello: I have a problem (polite way of saying 'I have no idea') when using transactions. I have read in some other threads, and in Microsoft's knowledge database, that it is not possible to use transactions with the docmd.runSQL object. So I am trying to figure out how to work with QueryDefs...

Hello again: First of all, thanks to everybody for your answers. Now Michael, actually you are right. This code shown is just some testing code I used to know how transactions work. The point was that I tried to do all the stuff with an String array (where the queries were) and then do a...

Hello: I have a problem with some code I am working with. I have a table with collections of products, and other table with the products. What I have to do is: when somebody buys a collection the program must take all the products belonging to that collection and insert them in another table...

Thanks, Moroeh P.D. Have a good Olympic games

Hi! I would like to know if there is a list, or something like that, where you can see all the error numbers (and their definitions) in vba code. Thanks, Igor