Search results for query: *

Thanks pjw001!! You solved it! Not sure how your brackets work but it works.... ;)

Hi there, I am wanting to run an insert that uses two values form two select statements. I think it should be clear what I'm trying to do. Basically get the two contact IDs for the first two values (and 4 for the relationship_type_id and 1 for is_active). INSERT INTO civicrm_relationship...

Hi all, We would really like a filter (button or checkbox) that when viewing a library, you could switch on and off depending on whether you wanted to see major versions only or major and minor versions. So, for example, you would see version: my_doc_1.0.docx my_doc_1.1.docx my_doc_1.2.docx...

Also tried this: function start() { new mq('m1',mqAry1,160); new mq('m2',mqAry2,160);// repeat for as many fuields as required clearTimeout(mqr[0].TO); mqRotate(mqr); // must come last } It does as in the original. Only works after the mouseover...

Hey BillyRayPreachersSon, I tried what you said. I changed the start method to the following: function start() { clearTimeout(mqr[0].TO); new mq('m1',mqAry1,160); new mq('m2',mqAry2,160);// repeat for as many fuields as required mqRotate(mqr); // must come last } Now I don't see...

Hi guys, I am pretty new to Javascript. I pulled some code of a tutorial website to make a scrolling marquee, then adjusted it to the size of my images. It seems to work OK. The only problem is, it only starts working when you put your mouse over it. I need to start scrolling automatically...

Hey guys, I know you can disable a SQL job. What I want to know is, if anyone can think of a clever way to disable a job step? Basically, I want to create a big SQL job with all the steps disabled. Then as the users of my app turn certain things on, the job steps should become activated (or...

Found the answer!! :D - Woo hoo!! No one told me about the '.' - seems like that's what you need. See the corrected SQL below: DECLARE @string VARCHAR (150) SET @string = '<Request><Addendum>Addendum1</Addendum><Addendum>Addendum2</Addendum></Request>' DECLARE @xml_xml_ptr INT...

Thanks! Looking foreward to hearing from you... Let me add the following: If I change my SQL query to the one below, I get a result set of two rows of NULL. In this case, at least it returns two values which I imagine correspond to the two Addendums. Now if I could only get the data...

oops. OK, here's the example: The problem is, it only returns Addendum1 and not Addendum2... Let me know if you can see a solution. --------------------------- DECLARE @string VARCHAR (200) SET @string = '<Request><Addendum>Addendum1</Addendum><Addendum>Addendum2</Addendum></Request>'...

Hey guys, If you could run the following SQL command: I am trying to extract two Addendum elements from the xml string. DECLARE @string VARCHAR (50) SET @string = '<Request><Addendum>Addendum1</Addendum><Addendum>Addendum2</Addendum></Request>' DECLARE @xml_xml_ptr INT EXEC...

Hi guys, My sql programming it not the best. What I want to do is insert the String 'Ñ' into a table. But the OSQL parser I am using keeps turning this into a 'N'. Does anyone know another way to insert this string? Perhaps by means of Char or Asci values? Let me know. Thanks G

the answer: how to update the last step of a job ------------------------------------- declare @numsteps INT SET @numsteps = (SELECT count (step_id) from msdb.dbo.sysjobsteps where job_id = (SELECT job_id from msdb.dbo.sysjobs where name = 'Postilion Office - Batch Process - Data Summary...

think im getting closer to a solution. i never realised (or never thought about the fact that) sp_update_jobstep is a normal stored procedure that i can look up in enteprise manager under msdb. now i can see which table it accesses msdb.sysjobs and msdb.sysjobsteps. now all i need to do is...

hmmm. I think they use a loop to increment jobstep id which kinda gives me an idea. I could maybe somehow loop through the job steps until I found the one which has attribute: on_success_action == 1 (quit with success). Then change it to on_success_action = 3 and then add my job step to the...

anyone else got any idea?

Yeh. Thats how I would do it too. But I need to write it in an SQL script so it can be rolled out and installed in the background at lots of different places. If someone has a different number of job steps, theres gonna be sql errors and the install will fail. :( anyone else got any idea...

Hi all. I am trying to update the last job step in a job, before adding a final job step to the end of the job. In the below example, the last job step number is 5. but this is not always the case. Is there a way to ask SQL to update the last job step?? Thanks. exec msdb..sp_update_jobstep...