Search results for query: *

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...

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...

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

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...