Has anyone done any work on producing a prepopulated PDF document from an SQL statement in ASP?
I've downloaded the FDF toolkit and had a look through the examples, but they all seem to involve the user clicking or entering data in a PDF form first and then getting the data from that. I basically just want to pull some data from a database using a query and use this to prepop and open the PDF.
The components have been installed on the server and seem to be running fine ie the FDF examples work fine, but I can't seem to work out this final step.
I am looking at expanding some search engine code of mine to include PDFs. Therefore I need some mechanism to extract the text from a PDF file which I can break down into individual words so I can index them.
Does anyone have any code or examples that will allow me to pull out the text of a PDF file in ASP?
This is something I must have spent hours searching for to no avail ;( .. Is there a way via classic ASP to issue a command to have a PDF file print? The code has the filename and path and all... All I need is a way to issue it to print! Is this at all possible?
I'm using the library fpdf.asp from www.aspxnet.it and when I generate the pdf succesfully, this pdf rest in caché memory, and when I try with other user to generated another pdf, Internet Explorer shows me the old pdf.My question is, How can the delete the caché merory?I try with the HTML meta tags, but if I do this, de IE only write the pdf tags not de pdf page because it have a bug with acrobat. I try with
Does anyone know if there are any IIS components out there that run on IIS 5.0 that will convert LaTeX to PDF? I have written a script in ASP that produces the LaTeX document, but am unsure of how to go about converting it to PDF and delivering it to the client.
If you don't know of one, do you have any idea of how I might implement such a transform? I would have to use a WshShell to run pdflatex on the source twice before I could deliver the PDF to the user. However, pdflatex outputs a PDF, so I would have to redirect the client to the PDF, and then somehow come along later and clean it up. I'm not sure if this would be the optimal process to take.
I have a project coming up soon where pdf files are stored in our oracle database. They want me to pull the pdf form out of the database and present it to the user on the screen. I've done a little searching on google, but haven't been able to find anything that helps. Can someone tell me if this is possible and if so, give a little example?
I've successfully managed to install the FDF-toolkit to my computer and I've also managed to create a PDF-file from a asp-page. But all of this have been for testing, now I want to implement this pdf-creating-service to a system for inquirys.
The salesman at the office uses a webpage to build their inquires and at the end I want to have a nice looking pdf for them to print. Is there anyone that knows how to actually create real dynamic pdf:s where the amount of pages and data varies a lot? If not, does anyone have an idea how to get good printouts from a webbrowser, where the text or tables dont get cut in the middle by the printer.
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 fire the following code on Index Server (different obj) and it returns a PDFs no problem, but when I change the object to use the MSSearch for Site Server I don't get any PDFs. Anything in the code that would cause this? I can see the PDFs getting crawled in Site Server, but when I try and search I don't get any pdfs .....
I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.
I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying
"Error Type:
Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. /SDATA.ASP, line 9"
can please anyone tell me why i am getting this error.
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
I'm current working on a project which need to upload local data to live server database.
Meanings that, i'm current having a server in my local mechine. I need upload data from local database to live database which host at oversea company. But i really have no idea how to do this in asp.
i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:
With regardst the above many-to-many relationship:
Is there any advantage in creating seperate access databases for:
- Customer - Products
....Rather than keeping them as three tables in one database.
The reason I ask is that I have found that if I am using a ftp approach to overwriting or updating the remote database there are sometimes problems with synchronizing data .....This seems to be a better solution?
does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.
I have built several websites before but none are database driven so is there any dummy proof versions?
I have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.
I want users to be able to Enter and update only their data not other users data.
Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.
I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.
They are on Windows 2000 IIS 5.0 and currently have an older version of their job database using Access hosted on a Brinkster server. The new server that they are on, when I contacted the host, they advised me against creating any new applications using Access, as the server is not meant for multi-users. So, I am thinking that they need to get their host to upgrade to a SQL database and have the job database developed using that. My question to this forum is: What do you think is the best combination for improvement here, SQL or MySQL or what, considering that their site is using asp and hosted on Win2000 IIS 5.0? Also, any recommendations on scripts that might be already available that could be customised to their site?
What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases. What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.
I have the following code to execute a SQL query.Code:
SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')" teamrs.Open SQL, conn all works fine. I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:
if sql = worked redirect else error end if so how can i make sure the query was executed successfully.
This is probably a stupid question (I'm good at those)... I would like to enable a user to be able to browse to a picture on their local machine and upload that picture to a remote directory where it can then be displayed along with it's other pertinent data. I thought it might be a good idea to use Front Page's "file upload" feature which includes a "browse" button and prompts me for a storing location - but I can't get it to work and am not even sure if that's its intended purpose. So my question is two-part, what should my insert or update page look like regarding an upload process, and then how would I link to or display that picture?
I have some questions in a database, i showed in the web page, for each questions i gave 3 (Yes, No, Not Applicable) options via select - option. when i get the variable with select name, it is showing with comma.
Example : If they select for like that
Ist question - Yes
IInd question - No
IIIrd question - Yes
IVth question - Not applicable
The variable is coming like (Yes, No, Yes, Not applicable)
I have a form that is inserting data to an access database i have it working, but when ever a user enters a name with a special character eg Tom O'Conor i get an error due to the ' character, is there anyway of over coming this problem.
i have this code that is supposed to help me out in some databse retrieval issue. however i am not aware of the dsn-less code and stuff: <% var rs = Server.CreateObject("ADODB.Recordset"); rs.Open("select * from states","DSN=IST_SQL;UID=....;pwd=....");
var n=0; while (!rs.EOF) { ... } rs.Close(); %>
i think the following is also to be included in the above code, but i am not sure of the whole connection thing.
Well Im finally getting how to do asp but I cannot seem to find where I import ms sql .sql files? I know in phpmyadmin there is a place to upload them but not anywhere in ms sql admin. Anyone know how to do this?
