I have two tables:
customermaster (id,name,email,mailinglists)
example: 1,john doe, Join Bytes!, NULL
emailmaster (email,listid)
example:
Join Bytes! 1
Join Bytes! 8
I want to get rid of the emailmaster table and merge the listids, into the mailinglists field inside customermaster so that I will have something like 1,8,14,25,99 in the mailinglists field for the email address Join Bytes. How can I accomplish this for MS SQL database?
I've done some research on how to do a MS Word merge with data I read
in an ASP application (using a SQL Server database).
I understand the concept since I've done it in a couple other
programming languages.
Does anyone know whether it is possible to effect a mail merge to MSWord
using VBScript in an asp file? I know it is possible to produce a doc
file and force a download using
Response.ContentType = "application/msword"
Response.AddHeader content-disposition","attachment;filename=myfile.doc"
but can I interate through a bunch of records and produce, say, a
separate invoice for each one by merging? I know how to iterate through
the records and write them out
Can someone tell me if it is possible to perform merge operations on a pdf file.
My client wants a user to fill in an on screen form and then have the results merged into a pdf template?
Granting that I have 2 recordsets with the same columns, is it possible to merge these two recordsets?
rs3 = rs1 + rs2 ???
Can someone show me how?
i have to merge 2 different images and save them as one individual image. I manage to overlap both images together in the same position but i'm having problem in saving the images as a single image. i hope anyone can help me with the problem.
View Replies View RelatedI have an ASP intranet application that is required to produce Word documents merged with data from a database.I originally looked at automating Word's mail merge capabilities, but nixed that idea since I learned it's not a good idea to try to automate Word on the server
decided to have the Word templates saved as RTF files and to write a parser/merger myself.since Word produces such complicated RTF code,until we decided that we were going to combine multiple templates into one final Word document with, potentiall, different header and footers for each section/template doc.
I'm having a problem figuring out how to get sections inserted into the combined RTF doc, so I'm thinking perhaps I should rethink my solution.how to produce database merged documents from templates created by users on a Web server? We may have some budget, sothird-party tools would be welcome, as well.
I used some example code from MS site (http://support.microsoft.com/kb/285176/en-us) to create an ASP page that executes a mail merge in word from a web page. For some reason when it attempts to run the getdata.asp part I always get theerror ..."The connection cannot be used to perform this operation. It is either closed or invalid in this context.
I have tried numerous ways to connecto to the database and form the record set but still get the same error.
HOW can asp open a *.doc and read it and extract mail merge tags and their definitions/values?
View Replies View RelatedI have a single table.
ID Code Description Colour Qty
1 0001 T-Shirt Black 5
2 0002 Soccer Ball Red 1
3 0001 T-Shirt Black 2
4 0001 T-Shirt Navy 6
What I need to do using ASP is take record 1 and merge it with record 3. By this I mean I need to show only a singular qty for the product code 0001.
i.e.
ID Code Description Colour Qty
1 0001 T-Shirt Black 7
2 0002 Soccer Ball Red 1
4 0001 T-Shirt Navy 6
I would like to sort my XML output and still be able to manipulate/alter/modify the XML data by use of some simple ASP code. (I’m going to slice it afterwards, and bake it in to a cornbread. But that’s a story for the cocking forum I’m a member off.)
I’ve no idea if this is ever going to work, but here is what I did.
- I’ve got an XML file; data.xml.
- I’ve got an XSL file; xmlxsl.xsl
The only reason I’m using a XSL file is because (I think) it will enable me to sort the XML data ascending. And of naturally a ASP script to merge al those files together and then to slightly modify the XML output. Code:
I want to merge a word document in the server to display in the client side. The merge code is in a dll. In the asp server script, I invoke the dll to merge.
It raise an error when I use the default IIS user. When I change the IIS user to administrator,It work well. how I should do to resolve this problem?
I have a document. Top right is a logo, there is a space for an address, space for content and space for extra details (3 sections). This can be seen as a normal word template.
I pull in information from a DB so have values: Address, Content, Details. I need to insert these values into their relevant places and produce the word document from the template so user can open/save it.
I need to take a bunch of PDFs that I have made using Appligent's FDFMerge and append them together. I know I could use Appligent's AppendPDF. But I was wondering if there were any free toolkits that I could use with a bit more work out there?
I cannot tell what on the Adobe site would be a candidate for me to even look at. The Acrobat SDK seems to be for Acrobat Reader plugins. Not what I am going for. The PDF library seems a candidate, but what *is* it? A C library? I cannot use a C library unless it has a COM wrapper.
I am working with an old line-feed printer text file. There are characters in the first position of each line that tell the printer what to do, i.e. print this line and advance paper, print and do not advance. when processing this text file for conversion to another text file I can't seem to work out the code for merging two lines. For example,
Type: Location: Quantity:
+ 123 London 45000
After processing the line should look like this:
Type: 123 Location: London Quantity: 45000
I understand the concept but have no idea how to actually merge the two lines with code.
I'm looking for a simple way to merge an image into another image.What i have is a screenshot uploader, and i want to make it so that when they upload the SS, the script will automatically merge a small copyright type image onto the bottom right of the picture.
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
View Replies View RelatedWe are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.
THE RESULTS:
(returns a blank page with only HTML Titles)
THE SCRIPT:
(you may notice this is a modified sample script): Code:
Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be.
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/admin/update.asp, line 111
line 11 is strName.execute
I read it might be forbiden characters in the data base field names or spaces...
but i don't have that. the names are userName, userLevel, ID, Password.
This seems a very complicated task, so I welcome any
input. My boss wants a data grid or matrix of the top 6
orders with ordered items, and products, for a particular
customer and he wants to see it like this:
products down the left side
orders across the top
number of items under the respective order number column
across from the corresponding product.
I hope that makes sense.
I have three tables. Products, Orders, Orderitems. I
don't even know where to start. Many thanks in advance
for any input offered.
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
how to call a csv file into a data array. I was told I can use :
csvArr = split(csvLine, ",")
So long as I have no embedded commas in any field. what Im not clear on is the syntax.
how do I call the csv into the script (so the script knows to use the csv)
I only want to input the following information if it is not a zero length string. Any
ideas on how to do it?
Crate&Barrel = Request.Form("Crate&Barrel")
Crate&Barreladdress = Request.Form("Crate&Barreladdress")
How can I display data from an XML file in ASP?I want to use an XML file instead of an Access or SQL database and would like to display this information the same as I would if I were using Access or SQL as the datasource.
View Replies View RelatedCan You Grab Data From Multiple Recordsets?I want to build a search page, but I have data in about 6 databases.
View Replies View Relatedhow to add new data. i need to add new data after display the record from database. i click new button and the textbox will be empty. Wat is the code for add new data?
View Replies View Relatedi'm trying to figure out how to use the same page to get different output using .asp?id=.
I have a db table with 5 records & want to on my page to be able to with a listbox/menu be able to switch between these 5 records using the same page.
I had write an asp file to get data from an xml named "data.xml" and below is the coding:
Dim xml
Set xml = Server.CreateObject("Microsoft.XMLDOM")
xml.async = False
xml.load (Server.MapPath("data.xml"))
Dim fText1, fText2
fText1 = xml.documentElement.childNodes(0).text
fText2 = xml.documentElement.childNodes(1).text
Set xml = Nothing
It's all Ok and can run. But my problem here is I want to call an xml file that I don't know its name (not "data.xml"). The xml file pass by the user who call my asp file. The user can pass the xml via anything for example asp or VB component. So I will not know exactly what the name of the xml file.
the actual question is as follows:
i have setup a DSN called "pro"
now i have tables in this database
i m running oracle
if i were using MS Access i know how to insert new fields by using the
RS.Mode = adModeReadWrite
how do i do it for oracle? not just inserting data into tables but also what r the commands that i have to give in the asp code page so that i can even update( edit ) and delete records.
I have a DB called users.mdb and it has the tables:
Myusers-
(fields) ID Name Password DOB Date joined
Messages-
(fields) ID Mailto Mailfrom Subject Content Postdate
I am trying to develop inbox.asp, how do i get it to display the mail for each articular user, and no one elses mail?
some way to access to the content of the HTTP POST? Perhaps throw the request object or something similar to the $HTTP_RAW_POST_DATA gobal variable available in PHP.
View Replies View RelatedI am having a lot of problems with this, I am trying to create a pdf file from data submitted by the user via a form.
Once the details are in the PDF the file needs moving into the secure area of the site.
Anyone have a clue how to do this?