Problems Writing Files To Database
I'm having some problems writing files to my Access database using ASP. I have a table with a couple of fields, one being of OLE datatype, that holds the file. I'm able to write and read small images, but I'm getting corrupted files when I try Word files, and my code is erroring out when I try to writing pdf files.
I think I've found the problem with the uploading of the pdf file (I think I need to adjust some IIS setting to allow larger file uploads), but I don't know what's going on with the word documents. They are small, so upload fine. Does anyone have any experience writing files to Access?
View Replies
ADVERTISEMENT
Does anyone know the ASP code for taking a PDF file and a Microsoft Excel spreadsheet and inserting them into an Oracle database?
View Replies
View Related
I have been playing with an idea that generates ASP files using an asp document and the file system object, so far it is doing great except one thing, when I have a chunk of text and I need to include an asp bracket ("<%" or "%>") regardless of being within the "quotation" marks the active asp document assumes it is a part of its own code and the script errors.
To get around this currently I am writing brackets like this "[<]" or "[>]" and then swapping them out of the generated ASP page using dreamweaver after creation.
The question is: Does anyone know how to represent asp brackets within a string being processed using asp??? Code:
View Replies
View Related
I'm writing a script lately to write some records into a text file for backup purpose. But may i know do asp allow update for the text file? Cause i dun want it to overwrite my previous records.
View Replies
View Related
In ASP, using PerlScript, how do you read and write to files?
View Replies
View Related
I'm planning a little asp prog that will allow me to read&write .ini files.
meaning, read lines that are:
key=value
and maybe even read from groups (optional):
[group 1]
key1=value1
[group 2]
key2=value2
View Replies
View Related
i am having problems figuring out the syntax used when writing information to a database thru a dropdown.
i have a dropdown w/ all the months listed and i need this recorded into a database where i have already set up a column named "month".
right now all i have is html that says:
Code:
<select name="month">
<option value="January">January</option>
<option value="March">March</option>
<option value="April">April</option>
....... and so on.......
</select>
View Replies
View Related
I cant seem to right to my asp database... This is my code. Code:
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open Server.MapPath("/db") & "/db.mdb"
ors = Server.CreateObject("ADODB.recordset")
sql = "SLECT * FROM members"
ors.open sql,conn,adOpenDynamic,adLockOptimistic,adCmdText
This is the error message I get...
Object doesn't support this property or method: 'ors.Open'
P.S - I have adovbs.inc included.
View Replies
View Related
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
View Replies
View Related
I have an asp form that sends data to a redirect page with SQL using JScript. There is a function that I'm using called replace(). The form submits without errors and goes to the redirect page but the data doesn't populate the SQL database. Instead, referrs to the last key ID. Code:
View Replies
View Related
I'm a newb - so if this is a stupid question, my apologies.
I have a simple form that users fill out and then that info is written to a database. What I'd like to do is perform a calcution on a number and then write those numbers to other records in the database.
So for instance, if someone enters 12 in one field1, it would multiply that by 3 and that would be saved as field2, then mulitply it by 45 and that would be field3, then add field2 and field3 and save that as field4.
I was thiking of passing the form variables to a second page instead of writing them to the database, then using variables in the second page to perform the calculations and then have the second page write all the info to the database, but I thought there had to be a better solution.
View Replies
View Related
After this statement, I want to be able to then show the data in the database in a recordor table view for the user. Any ideas?
'Check if username doesn't already exist
do while not rs.EOF
if rs("username")=Request("Username") then
set rs=nothing
set conn=nothing
Response.Redirect("login.asp?login=createnamefailed")
end if
rs.MoveNext
loop
View Replies
View Related
i would like to write information to an access database. I have tried websites that have scripts but the ones i have saw are fairly complicated. All i have is a form for the user to input information and then i want it to write to a pasific table in microsoft access. how to do this.
View Replies
View Related
When inserting multiple lines into a database asp removes the whitespace so:
hello
all
becomes
hello all
is there any way to detect the return and inset it as intended ie:
hello
all
View Replies
View Related
I am tring to create a front end for this Access Database someone has given me and i have trawled through these and other forums for the answer to my question but have not found anything!!
I have used 4 checkboxes in a form with 4 different names, when i try and create a record in the access database which uses the Yes/No Field Type it displays the error, " Provider error '80020005'
type mismatch" when trying to right the value into the field!
View Replies
View Related
I am trying to write an array of random numbers to a database. The array part is working fine, but when I go to update the dataabse, it inserts the last value of the array into all the fields in the database .....
Dim MyValue,sqlRandom
Dim arrayRandom(8)
for i = 1 to 8
Randomize
MyValue = Int((100 * Rnd) + 1)
arrayRandom(i) = MyValue
response.write "<p> Array Value:" & arrayRandom(i)
sqlRandom = "UPDATE CarParkDetails SET FreeSpaces = '" & arrayRandom(i) & "'"
Conn.execute(sqlRandom)
next
I can't see whats wrong!
View Replies
View Related
Here's my question/problem:
What is the best route to go to store images and 'news articles' in a database?
Is it best to give each an ID(autonumber) and then another field set in a table in access equal to the url for the said file
For example..: www.domain.com/?file=1234
In my access table I would have file 1234 equal to suchandsuch.inc or html or whatever
View Replies
View Related
how to download files from database to a certain path. using asp and sql server 7
View Replies
View Related
I am doing a flash map with different categories-shops, services etc.
I want when people click on shops to view all the shops icons(buttons) in the map. They have to be pulled from a database using ASP. How do you save and pull swf files in Access database?
View Replies
View Related
I am developing a forum style website using ASP and I need to have a file attachment function when people post notices. Does anyone know how to do this? So far has only helped with showing me how to upload files to a server but I need to upload them into the access database to retrieve it when needed. Is this possible?
View Replies
View Related
i am working with asp form where the user can upload files to a folder or to the database, uploading files in folder in working, but the database one is not working it give me the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/test/uploadexmple.asp, line 48
and here is my code:
View Replies
View Related
I have intermediate experience with asp, and sql. I am stumped on how to properly do a project, and hoping that one of you can point me in the right direction instead of playing the trial/error game for 2 weeks!!
Basically, I have a program that exports information into a html file for viewing of results. The file contains event information, user information, and results of each individual user along with statistics of the event. I want to take this generated file, and import it directly into a sql database (point and click upload of sorts to be user friendly) for further data mining. Code:
View Replies
View Related
I want to upload a file then add a record in a database using info from the uploaded file. I can't figure this out. If anyone has something working that isn't this please let me know. I would rather have this working as I don't want to recode the whole thing.
First the upload doesn't work. The MBRequest(file1).Save isn't supported in this manner. I know you can use .save to upload a file.
Second You'll see that MBRequest is called to form a filename. The filename is called in another page to form a link to the file......
View Replies
View Related
I have just uploaded the files to a where they will reside and am now getting the following error
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file '
syd9004papc$InetpubwwwrootGMS_Statsgms_st ats.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
I have checked IIS on the server where this DB resides and have allowed as much rights as I can ... Has anyone seen this error before? I realise it must have something to do with security but I don't know if it's IIS or DB related?
View Replies
View Related
I have attached the file upoading system in this thread.
It is working fine with MS Access Database but when i change the database to MS Sql Server then its upload not works i think its security problem, or the problem is that when i import the MS Access table into MS SQL server it change the field datatype from oleobject to image.
View Replies
View Related
is it possible to download binary files from database(sql).. ?
View Replies
View Related
I write search files webpage.when users enter part or all of a file name and asp page send back a list of only the files(that user can click to open files) whose names contain the text they entered.I want to save data about accessing files such as file name ,accessed date of fileto my database(Microsoft Access).I don't know how to write a adding code to do this. Code:
View Replies
View Related
I don't know how to upload word doc, images and other files into Oracle Blob fields with binary format.
I tried with the following code, normally it's inserting, suppose if i try to convery binary. Code:
View Replies
View Related
Ok, for my company, we have two current webpages, one for general company info and one specific to a product that we market. On the 2nd page, there is a form that allows users to request a consultation from the company. When it is sent, the information is stored in an Access DB for tracking purposes.
Now, I have been requested to put this same form on the general company website. All works fine, but I can't save to the db that is stroing the info once it is submitted. Boith sites are hosted by the smae company, but they do not have (as far as I know), a shared repository for files where I could put the db.
Does anyone have any suggestions as to how I can get around this issue? What I want to do is to have the form on both sites and have the submitted data saved into the one database.
View Replies
View Related
I'm not getting error messages on this one so I don't know where to start looking. I type in my data in my form and this page should check it, add it then set a flag. Code:
View Replies
View Related
I have to perform a database query and write the results to an XML
file.
I also need to form this XML file with a DTD file.
I'd like to hear some opinions on the best way to do this.
I figured out how to write out just raw XML using adPersistXML. But
that doesn't really help as the XML needs to conform to the DTD.
I also found a way to write out the XML file line by line
using .createNode and .appendChild...but that would take forever as
the database query returns 72 columns.
View Replies
View Related
i need have a problem on line 86 of this code. Could anyone suggest problmes.
The bit in red is where i think the problem is, but may be wrong. it is where it says the problem is in the browser when i go to run it Code:
View Replies
View Related
I have the following code as a part of authenticating a system.
If Rs.eof Then
Session("Authenticated") = 0
Response.Write "Sorry, your userid or password did not match"
Response.Write "<BR>"
Response.Write "or you have not registered yet. Please register"
Response.Redirect("login.asp")
Else
Session("Authenticated") = 1
Response.Redirect ("Welcome.asp")
End If
In the first if statement, I would like to display the above messages
before forcing the login.asp page to display. Is is possible to do both
message and contents of login.asp in the same page? Thanks
View Replies
View Related