We are trying to generate the following XML on a client machine:
<Emp EmpId="1" EmpName="Ann">
<Emp EmpId="2" EmpName="Bob">
<Emp EmpId="4" EmpName="Dave" />
<Emp EmpId="5" EmpName="Frank" />
</Emp>
<Emp EmpId="3" EmpName="Cara">...
User Profile
Collapse
-
VB.Net Function to create xml string
-
I did get the triggers to fire on the Bulk Insert. Thanks for all of the help guys. -
I am not using a query. I am using the dts wizard that came with SQL Server 2005 Express.
You wouldn't know how to get the trigger to fire in that instance would you?
I may have to look at the bulk insert function....Leave a comment:
-
What about when you execute the DTS Wizard? I am trying to insert new rows and update the information in other tables using the triggers. The triggers will not fire. Any ideas. I'm searching the Web up and down.
Thanks for your help.Leave a comment:
-
Fire an SQL Server Trigger on a Bulk Upload
Hello,
Does anyone know how to get a trigger to fire while you are uploading multiple records into a SQL Server 2005 Express DB using the DTS Wizard?
On insert of a person's record I want the trigger to find their id# from another table and update their information accordingly.
I have the trigger built, but it will not fire when I use the DTS Wizard.
Please help. Thanks. -
No, the numerous tests that I have done have all returned various numbers of characters, so the length of the message seems not to be the issue. Could you post an example of that wait code? I've been searching for code like that, but have not found it. Thanks....Leave a comment:
-
Ok. The idea of creating a table for the IDs did not work, so I am back to square one. Anyone have any ideas on this?
I need to find a way for the CDO message to finish inserting the text of the message before it sends the message to the user. It's not a matter of size and not a matter of a limit on the number of characters, so that just leaves increasing the amount of time that the message has to insert the text before it sends...Leave a comment:
-
Yes. I create the message and place it in a variable and then where you writeCode:<%myMail.HTMLBody=message%>
I did some playing with it Friday and discovered that you have only so much room horizontally and vertically to work with. I'm going to try and place the list of IDs in a table and see if that works. I will update you as soon as...Leave a comment:
-
This example works great for me, but do you know how to have the excel file automatically attach it to an email being sent out by a CDO message?Leave a comment:
-
I mean the length of the message and the size of the file itself when it reachs your inbox. I am trying to dynamically create the message, but it continues to get cut off at 10KB in size.
I do not have control of the smtp server, but was told that the maximum size of an email going across our network is 6mb. I'm nowhere near that.
Any other suggestions?
Thank you again for assisting me.Leave a comment:
-
CDO Message Maximum Message Size
Does anyone know how to increase the maximum size of a CDO Message sent by as ASP page? The maximum I've seen is 10KB. Thanks. -
Thank you to both of you for your help. I did get it to work and it works beautifully now. I managed to fool with it and found out that I did not have the some things done correctly, like using the value of the listbox option instead of the id for it and I changed the div to a span. Thanks again.Leave a comment:
-
No. I'm not get any errors, I'm not getting anything at all in the div.
Should the listbox read like this?
[CODE]
"><form id="form3" name="form3" method="get">
<select name="selectlis t" size="10" id="list"onfocu s="show(<%=rsS( "ID")%>)">
<%while not rsS.eof%>
<option id="<%=rsS("ID" )%>"><%=...Leave a comment:
-
ASP and AJAX problems
Hello,
I am having problems with using AJAX to call information to my primary ASP page from a secondary asp page that brings in the data I want to display.
I'm having the onfocus event trigger the function show() to call in the data from the secondary asp page. However, when I click on the record in the list, nothing happens. The information is suppose to appear ni the div id = "div_id". Please help. I...
No activity results to display
Show More
Leave a comment: