i made a table in sql server 2000 and in a column i want to
add image path of a picture present in my hardisk... so
using insert statement how will i insert the path of the
image in the table??

Answer Posted / anuj maheshwari

suppose your url is c://documents/image1.jpg.

1st on ur form , put one this property. "ecytype=mulipleform".
by this , u can upload your file on your destination. and
store your path in a one variable and put it into your
insert query. this is way to insert a path in a database.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which storage engine is best in mysql?

478


What is int mysql?

519


How do you create a new database in mysql?

465


List data types in mysql? Explain

476


What are mysql queries?

484






What is difference between function and procedure in mysql?

456


what is the difference between between and in operators in mysql?

503


How do I copy a table in mysql workbench?

456


Can we store pdf files in mysql?

476


What is user in mysql?

441


What are the similarities between a function and a procedure?

455


What is mysql_query?

465


What is mysql workbench used for?

514


Write a query to display current date and time?

518


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2422