Search results for query: *

I do have XMLSpy but it only generates the header of the XML document, and not the rest. If you could generate an XML file that would be AWESOME! Thanks for the help. Here is my schema: <?xml version="1.0" encoding="UTF-8"?> <!-- edited with XMLSPY v5 rel. 3 U (http://www.xmlspy.com) by...

What is the easiest way to generate a sample XML file from an already created XSD file? Thanks! Brad Williams Webmaster

Ok here is what I am trying to do. I have a XSD Schema already created. I need to use this schema to generate an XML document from data in SQL Server 2000. Is anyone familiar with how to link an XSD Schema to either a stored procedure, or a query to plug in my data to generate an XML file...

1) That is what it has to be divided by to figure out my formula 2) It was just an example. The order ID will be whatever I type in 3) Every order ID has ONE po ID attached to it, never more than one 4) Yes there can be, but for the sake of simpleness I just want to figure out how to do this to...

Here is my query: SELECT o.orderid, o.po_id, ((SUM(op.quantity) / 3) / 4) as itemtotal, COUNT(*) as counter FROM orders o INNER JOIN order_products op ON o.OrderID = op.OrderID INNER JOIN applications a ON op.app_ID = a.app_id INNER JOIN products p ON a.prodcode = p.prodcode WHERE o.orderid =...

I posted it on planetsourcecode.com: http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=8804&lngWId=4 Brad Williams Webmaster

I fixed it already. Thanks anyways! Brad Williams Webmaster

From the server Brad Williams Webmaster

Got it! pop3.DeleteSingleMessage x That isn't even in the manual!! Thanks for the help! Brad Williams Webmaster

Change that causes an error. I went ahead and used FSO to rename the file: If ( InStr(at.Name, "jpg") > 0 OR InStr(at.Name, "gif") > 0 ) Then Randomize timer randnum = int(rnd * 10000000) filename = randnum filename = filename & ".gif" Dim fso Set fso =...

at.SaveToFile( "c:\directory\my\files\go\in\" & at.Name ) that is the line where it saves it. Brad Williams Webmaster

Yes ASP. Yes I can save the attachments just fine, but I'm trying to figure out if it supports renaming. Here is my code: <% @LANGUAGE=VBSCRIPT%> <% Set pop3 = Server.CreateObject( "JMail.POP3" ) pop3.Connect "email@mydomain.com", "password", "mail.mydomain.com" Function getEmail(x) if...

I'm not sending emails with JMail, I'm receiving emails in to my pop account. Reading the emails and downloading the attachments on to my web server. I could probably make the FSO work, but it would really be a pretty heafty work around. Brad Williams Webmaster

Post your error code. Also look at this: RESPONSE.Write "<option value='"&RS1.FIELDS("CogDeptCode")&"'>"&RS1.FIELDS("CogDeptCode") Your not closing your <option> tag, so do this: RESPONSE.Write "<option value='"&RS1.FIELDS("CogDeptCode")&"'>"&RS1.FIELDS("CogDeptCode")&"</option>" Brad...

Your dataconnection is closed. Brad Williams Webmaster

Hello, I am working on a script using the JMail component. Right now I've made it so it logs in to my pop mail account, grabs all of the attachments it finds, and saves them to my web server. That all works just fine. What I am trying to figure out is two things: 1. How can I delete the...

I was afraid that would be the answer. I can reformat the DB, but it is a highly used, very public table so it is a bit of a pain. I guess I'll do that. Brad Williams Webmaster

You need to create a "Printer Friendly" version of the report. You can then use simple HTML tables to format the report as you want. Brad Williams Webmaster

I have a field in my database that contains multiple values seperated by a comma: ex: value1, value2, value3, value4, value5 This field could contain one value or more. I am trying to break the values apart by the comma, and then tally up the total of entries for that particular item in the...

I got a word document thats 434 pages of drinking games that I want to import into my SQL Server DB. Here is the format of the text: ABSOLUTE STRESS 1 oz Asolute Vodka / 1 oz Peach Schnapps 1/2 pineapple juice /1/2 cranberry juice ice (shake) / rocks or blended \ frozen ABSOLUT BLUE...