You would think so, wouldn't you. I have tried it, and SQL is screaming... giving me an "ADO Error: Syntax error or access violation" error.
Here is the actualy code.
SELECT document_groups_members.group_id, document_groups_members.document_id, @job_id
FROM document_groups_members...
I need to select all of the rows in a given table that match a criteria, and them add them back onto the same table while specifying a third value.
It's a three column table (a, b, c) and all three make the key.
I need to select a, b, where c=1 and append them to the same table while making...
Thanks BolderBUm, but that is the part I have figured out already. Pass a value, err the key value, to the details page. Receive the value on the Detail page and then bring up the correct record.
What I am struggling with is how to get the value out of the selected row. I cannot figure out...
Ok, I have a nice datagrid that lists may table information all pretty.
Now I need to be able to edit the data. I do not want to use the builtin data editing on a datagrid, i would prefer to kick to another page that has an edit/update form.
My theory is that the way to do this is to use the...
I am viewing the mail boxes in the exchange system manager. I have noticed that there are several accounts that show the "Last Logged on By" as a different user than the mailbox owner.
For example..
Mailbox A, Mailbox B, and Mailbox C all show the "Last Logged on By" as...
I am having a similar problem. How do I change the Timeout Setting within Outlook.
Here is my scenario...
1 Dialup to internet.
2 Open Outlook.
3 Check for new mail.
At this point, the VPN client asked for name and password and authenticates. But if I am not rocket fast, Outlook will...
Hey all,
I am setting up a Cisco 1200 Access Point. I need some assistance setting the unit up for MAC filtering.
I have checked the manual, but the web interface on the device is nothing like what is referenced in the manual.
I would appreaciate some help if anyone else has used this thing.
Yeah, you are right. What I am looking for though is something to actually move and recreate the shares.
Copy the files, and then create the share at the new location or repoint the share.
Hello...
Ok, here is the deal. I have a series of shares on a Windows 2000 server that need to be moved to another volume. The shares comprise about 30 gig.
I need to copy all of the contents to the new volume, then recreate the shares to point to the new volume. Whats the best way of...
Ok, here is an interesting question that I hope someone can answer although I tink I might know the answer already.
I have a Windows 2000 Server, sp3. On this server is a shared folder containing a ton of stuff, including a large subfolder tree.
Last night, someone "accidentally"...
I am having a strange bug.
I have a form that shows in datasheet view. When a certain field/control (ctl1) looses focus a modle is run to validate the field contents. If the contents are invalid, i want the control (ctl1) to give have the focus again.
I am attempting this using the simple...
Ok. I figured that much out, but thank you. How do I refer to the control in said code?
The control will be different each time the code is called, so i cannot hard-code the control name.
So I am back to this, how do i pass the refernce to the control or call the control by a generic name...
Ok. Here is what I need to do. I have a block of code that is triggered by a Textbox control getting the focus. This code basically highlights the contents of the field so it can be overwritten by typing over the data.
I need to apply this code to all text boxes on the form. I do not want...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.