I am struggling to store an image path to a mysql database and in the process copy the image from one folder to the folder I would like it to be copied to.
My code for the inserting the image path and data into the mysql db is below: ....
Anyone there can help suggest to me where i can find out more about Inserting image into a database.
View Replies View Relatedthis is the code im trying to use to insert a date to mysql db:
dim myquery
dim datew
datew = formatdatetime(date())
myquery = "INSERT INTO article (date) VALUES ('" & datew & "')"
this inserts a date but its always "0000-00-00", i want to get the actual date and add it to the table.
I'm working on a project where I'm suppose to upload a image to a server. The uploading works fine but when I want to change the image I uploaded to another image I can't get the filepath of the old image to show in my "filefiled"....is it possible to set a "value" where I can retrieve a filepath in a form if the input type is "file"?
View Replies View RelatedI have a serious problem at hand. I am developing a web application where several users will be inserting, updating, deleting data in mySQL databases based on their user ids. I have created a session variable at login which gets to be displayed on all my pages---web pages. Now the challenge is to get this session variable inserted into mySQL data base when a given user is on a given dynamic page. Code:
View Replies View Relatedwhen using a relative image path
const imgDir = "_images/divisions/"
the relative path is converted to a physical path in an img tag as <img src="c:app\_imagesdivisionsmypicture.gif">
how can I prevent this from being converted to a physical path ?
I created a table with varchar field where i want to store
the path of an image.
I will then use this file to retrieve this image on my
browser. Everything goes fine when i use a simple html
command as :
<img src="C:InetpubwwwrootMyWebimagesone.jpg"
height="200" width="200">
this is a hard-coded path. Hence no problem.
But when I store in the database path value: Code:
I have 1 form that put some text in Acces. After submitting that form there comes a form where 4 images can be uploaded. These image are stored in a folder on the webserver. Can I save the path to the image in the record (id) of the textfiles in Acces?
View Replies View RelatedI have a subdirectory with it's own images folder. All the image paths in the pages in the sub directory are "image/image.jpg" When I Response.Redirect to a page in the subdirectory the images are fine but when I use Server.Transfer all the links are broken. I'd prefer to use the relative paths. Is there a way around this in the Server.Transfer?
View Replies View RelatedHow do i insert images into a database? Can anyone recommend a tutorial or website ?
View Replies View RelatedI need Help in inserting the user image in my data base. but
unfortunatly I don't know how.I'm using asp with sql server. I tried to
insert the image and i geuss it worked.for the field in the db in not
null and it have this value <Binary> . but when i try to select it in
gives me this error "An unhandled data type was encountered".
this is my code :
I am working on a asp and sql website that I did not make. It runs an asp based content management system, where users can enter news articles. They enter the "body" into a text box/area and can add images separatly. The image will show up to the to left of the article.
This goes into a SQL database, and gets pulled out by asp for the webpage. I want to make it so a user can add in an image into the body of the article ( like in a word document ) and have it show up where they put it. What is the easiest way to do this. Both easy on me and the user.
I have searched around the web and have yet to discover a "HOW TO" for this, tho there are lots for PHP.
So I am asking if any one in here got a clue on how to do it? I am using a simple form and want the image stored in the MySQL with the 3 fields (ID, Path and Blob).
Any one got any ideas?
explain abt copy files from IIS image path to local client's machine.
View Replies View RelatedWould someone be able to explain the sql image field to me. I was reading about it a little but dont really understand.
I would like to have word documents that can be indexed and searched and i heard the image field with an accompanying char field with the file extension would be the trick. how would i actually get binary files into the image field?
I wanted to write an asp script so users could enter .doc that they could query. I understand basic asp sql inserts.
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.
if you need to place the path to your database, what path do you place when you are having you site hosted by a web hosting company. For example my database is in a folder called "db" and its called "company.mdb"
the path I'm using is: "Data Source=c:dbcompanx.mdb"
but I keep getting a "database can't be found error" what path am I to assume they used. I mean its probably not a "C" drive so what do I place? I tried it without placing the drive but it doesn't work it seems to want only the direct path.
I downloaded the below code to add my project, but I would like to know how can I change the path of my database to /db/forumMDB? , and why ForumMDB instead forum.mdb?
Code:
Dim rsForums
Set rsForums = Connect (ForumMDB).Execute ("SELECT * FROM Forums ORDER BY Forum ASC")
rsForums.MoveFirst
structure of my folders:
/forum -------here I want to put my forum code
/db------------here I want my db of my forum
/Misc
default.asp
I am getting the following error from the following code:
Server.MapPath(), ASP 0172 (0x80004005)
The Path parameter for the MapPath method must be a virtual path. A physical path was used.
/html/objconn.asp, line 11
The code is as follows....
What is the best/common practice when configuring the database path?When the asp application is distributed to customers. How can I facilitate trouble-free installation?. In my applications I use servermappath to determine the position of my files, but databases (Access) are usually stored in different folder structures depending
on the servers.
What is usually done to configure an application?? Ask the administrator/customer to edit global.asa manually? Is there a way to make this task easier for non experienced customers? Is the connect string with the path usually stored in global.asa or in an include file?
I had some Error when i write the update sqlp query
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/fyp/Quiz/updateQuiz.asp, line 21, column 77
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"
Code:
SQL_query= "update Activity_Status set UserID = '" +Request.Form("username") "'" "where Score = '" +Request.Form("QuizScore" + "'")"
I have the folllowing page where a user can add a review to the website. So far the page works fine, but on the review rating section I know that the rating is between 0 - 5.
But its posible for a user to enter 1000 if they wished, which still means the page works but the answer is too high.
Also if they write text in the field it errors the page. How do i code this so that they can only enter a number between 0 and 5 and only a number and not text.
I have a problem with inserting the results of which radio button was selected into a database. I have the code for the text fields down with no problems. I guess my question is how to populate the yes/no fields in the access database.
View Replies View RelatedDatabase path works on drive c:, but it doesn't work on a mapped network drive while i move the database to the mapped network drive it stops working.
Can anybody help how can I write Access Database Path to a mapped Network drive in my vb script?
I am having trouble with someone else's code that worked when it was used last, but now it's not. I am new to ASP programming so I not too sure what's happening. Code:
View Replies View RelatedI have a table in access that contains to primary keys, they are both defined as numbers and I want to insert data into them in ASP:
I've tried a couple of statements as follows:
strADDIDQuery = "INSERT INTO [Jnct LP Obj] (LessonPlanID, ObjectivesID)VALUES " & strLessonPlanID , & strObjID
This tells me that an end of statement is expected:
and this:
strADDIDQuery = "INSERT INTO [Jnct LP Obj] (LessonPlanID, ObjectivesID)VALUES " & strLessonPlanID & "','" & strObjID & "')"
just doesn't work (page cannot be displayed)I'm sure it's a sytnax problem, something to do with integers? but I've searched loads of sites and can't find any that are using simliar code:
The values are pulled from a form as follows:
strLessonPlanID = cInt(request.Form("LPID"))
strObjID = cInt(request.Form("OBJID"))
what the best way to update a ms access database from an asp page is.I have a db with 3 different tables,these tables are bound to each other via the relationships.
On my asp page,I want to create one page where the user would enter in information and hit submit.The problem I have though is that how do I have only one button that will update information from 3 or more tables all at once?
I have a page setup where a user can login and add news to a site.
I had to write a small function to eliminate any apostrophies or dashes in the SQL insert statemnet to prevent any errors or confusion.
My question is, is there an easier way to do this? ....
I have simple form that sends data to an access database. The action is listed below. Am i missing a connector somewhere? Code:
View Replies View RelatedI want to insert multiple records in my SQL database. I was wondering if this is the right way to do it: PHP Code:
set insertRecords = Server.CreateObject("ADODB.Recordset")
insertRecords.ActiveConnection = mlConn
For i = 0 To 5
insertRecords.Source = "INSERT INTO Info (Name, Age) VALUES (" & getName & ", 20)"
insertRecords.Open()
Next
I am currently developing a coursework for uni that involves inserting some values into a Access database. I know how to do this, however I am trying to use different insert statements to insert data into different tables, however all the input field are on the same page. Code:
View Replies View RelatedI have an ASP variable called IRNvar:
If IRNvar(0,num) = "True" then
IRNvar(0,num) = 1
else
IRNvar(0,num) = 0
end if
In my sql database I have a True/False field called VariantFlag which is a bit data type. The IRNvar value is numeric. I am trying to insert the 1 or 0 into the database so that the field shows true or false accordingly but I get a 'Type Mismatch' error. Here's the insert statement:
SQL = "INSERT INTO Documents (CNID, DocumentPrefix, DocCategory, DocumentName, VariantFlag, PartNo, PartDesc, NewIssue, StatusID) VALUES ('" & CNID & "', '" & IRNprefix & "', '" & IRNcat & "', '" & IRNnumber & "', " & IRNvar & ", '" & PartNum & "', '" & IRNDesc(0,num) & "', 'A', '5')"
Is there a way to convert the number to the right data type? Am I doing something wrong? I'm quite new to all this so it's probably something silly.
i am trying to use the 'Insert into' sql query to insert data in an asp file but having some errors...this is the eror i got from the browser..
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/AddConfirm.asp, line 46, column 36
sql="INSERT INTO tblMembers VALUES("8"," & DateJoined & "",""& Title& "",""& LastName& "",""&FirstName& "",""& DOB & "",""& AddressUnit&"""
this is the code i have in my asp file....
Code: