User Profile

Collapse

Profile Sidebar

Collapse
srkidd12
srkidd12
Last Activity: May 5 '11, 02:05 AM
Joined: Jan 22 '08
Location: Charlotte, NC
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • srkidd12
    started a topic VB.Net Function to create xml string

    VB.Net Function to create xml string

    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">...
    See more | Go to post

  • I did get the triggers to fire on the Bulk Insert. Thanks for all of the help guys.
    See more | Go to post

    Leave a comment:


  • 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....
    See more | Go to post

    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.
    See more | Go to post

    Leave a comment:


  • srkidd12
    started a topic Fire an SQL Server Trigger on a Bulk Upload

    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.
    See more | Go to post

  • srkidd12
    replied to CDO Message Maximum Message Size
    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....
    See more | Go to post

    Leave a comment:


  • srkidd12
    replied to CDO Message Maximum Message Size
    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...
    See more | Go to post

    Leave a comment:


  • srkidd12
    replied to CDO Message Maximum Message Size
    Yes. I create the message and place it in a variable and then where you write
    Code:
    <%myMail.HTMLBody=message%>
    Message is a variable that holds the entire message, but it still drops part of the 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...
    See more | Go to post

    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?
    See more | Go to post

    Leave a comment:


  • srkidd12
    replied to CDO Message Maximum Message Size
    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.
    See more | Go to post

    Leave a comment:


  • srkidd12
    started a topic CDO Message Maximum Message Size

    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.
    See more | Go to post

  • srkidd12
    replied to ASP and AJAX problems
    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.
    See more | Go to post

    Leave a comment:


  • srkidd12
    replied to ASP and AJAX problems
    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" )%>"><%=...
    See more | Go to post

    Leave a comment:


  • srkidd12
    started a topic ASP and AJAX problems

    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...
    See more | Go to post
No activity results to display
Show More
Working...