Click here to Skip to main content
15,867,594 members
Home / Discussions / Database
   

Database

 
QuestionWhy does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 2:35
professionalfd97507-Sep-20 2:35 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
Jörgen Andersson7-Sep-20 4:18
professionalJörgen Andersson7-Sep-20 4:18 
GeneralRe: Why does MySQL not convert dates before 2010-01-01? Pin
fd97507-Sep-20 21:14
professionalfd97507-Sep-20 21:14 
AnswerRe: Why does MySQL not convert dates before 2010-01-01? Pin
ZurdoDev21-Sep-20 7:03
professionalZurdoDev21-Sep-20 7:03 
QuestionHow to use a FileInfo control to add a filename to an Access database Pin
rodgerm25-Aug-20 14:51
rodgerm25-Aug-20 14:51 
I'm trying to add both text and a picture filename to an Access database. The actual .jpg file is stored separately in another folder. I want to use a File control in classic ASP to do this. If I create a page for the text fields and a separate page for the File control, everything works fine but the users are confused by having to go to two pages.

Ideally, they would use the Browse button of the File control to select their picture then the picture's filename would be passed down to the "ImageLink" field in the database Insert SQL command. Any ideas?

Here's my two sections of code:

HTML
<form action="marketplaceentryadd.asp" method="post" >
<!-- Begin data entry table -->
<table border=1 cellpadding=3 cellspacing=1>
<tr><td size="110"><font color="#FFFFFF">Country:<br />
</font></td><td><input name="txtCountry" type="text" size="50" maxlength="50"  /></td></tr>
<tr><td><font color="#FFFFFF">Description:<br />(255 char. max)
</font></td><td><input type="text" name="txtDescription" textmode="multiline" maxlength="255" size="50"/></td></tr>
<tr><td><font color="#FFFFFF">Price:<br/>
  Numbers only with optional decimal point
</font></td><td><input name="txtPrice" type="text" size="50" maxlength="50" /></td></tr>
<tr><td><font color="#FFFFFF">Your Name:<br />
</font></td><td><input name="txtSeller" type="text" size="50" maxlength="50" /></td></tr>
<tr><td><font color="#FFFFFF">Contact Info:<br />
  (255 char. max)
</font></td><td><input name="txtContactInfo" type="text" size="50" maxlength="50" /></td></tr>
<tr><td><font color="#FFFFFF">More Info:<br />
  (255 char. max)
</font></td><td><input name="txtMoreInfo" type="text" size="50" maxlength="255" /></td></tr>
<tr><td><font color="#FFFFFF">Picture Filename:<br/>Do not include spaces in the filename<br/>Be sure to include extension (.jpg)</font></td><td><input name="txtImagelink" type="text" size="50" maxlength="50" /></td></tr>
<tr>
	<td><input type="submit" value="Add Item" />
</tr>
</table>

</form>


Second page code:

HTML
Please select picture to be saved for this item:<br/><br/>
<FORM method="post" encType="multipart/form-data" action="ToFileSystem.asp">
	<INPUT type="File" name="File1"><br/><br/>
	<INPUT type="Submit" value="Upload Picture">
</FORM>

AnswerRe: How to use a FileInfo control to add a filename to an Access database Pin
Richard MacCutchan25-Aug-20 21:16
mveRichard MacCutchan25-Aug-20 21:16 
QuestionDATABASE KEY Pin
Member 1492238425-Aug-20 0:42
Member 1492238425-Aug-20 0:42 
AnswerRe: DATABASE KEY Pin
OriginalGriff25-Aug-20 0:45
mveOriginalGriff25-Aug-20 0:45 
AnswerRe: DATABASE KEY Pin
ZurdoDev31-Aug-20 9:45
professionalZurdoDev31-Aug-20 9:45 
AnswerRe: DATABASE KEY Pin
Eddy Vluggen24-Sep-20 8:12
professionalEddy Vluggen24-Sep-20 8:12 
QuestionAny recommendations ora 01722 ??? Pin
Mahmoud Mohammad23-Aug-20 23:26
Mahmoud Mohammad23-Aug-20 23:26 
AnswerRe: Any recommendations ora 01722 ??? Pin
Richard Deeming24-Aug-20 0:42
mveRichard Deeming24-Aug-20 0:42 
Questionsql server express 2014 named instance not connecting from outside network Pin
Member 1258438314-Aug-20 1:28
Member 1258438314-Aug-20 1:28 
AnswerRe: sql server express 2014 named instance not connecting from outside network Pin
Sandeep Mewara18-Aug-20 23:17
mveSandeep Mewara18-Aug-20 23:17 
QuestionAny good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 0:01
mveSandeep Mewara14-Aug-20 0:01 
AnswerRe: Any good tool (free) for DB Schema? Pin
Richard MacCutchan14-Aug-20 1:44
mveRichard MacCutchan14-Aug-20 1:44 
GeneralRe: Any good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 1:45
mveSandeep Mewara14-Aug-20 1:45 
GeneralRe: Any good tool (free) for DB Schema? Pin
Jörgen Andersson14-Aug-20 3:24
professionalJörgen Andersson14-Aug-20 3:24 
GeneralRe: Any good tool (free) for DB Schema? Pin
Sandeep Mewara14-Aug-20 3:39
mveSandeep Mewara14-Aug-20 3:39 
QuestionMS SQL Database Breach Pin
Otekpo Emmanuel13-Aug-20 4:03
Otekpo Emmanuel13-Aug-20 4:03 
AnswerRe: MS SQL Database Bridge Pin
Richard MacCutchan13-Aug-20 4:14
mveRichard MacCutchan13-Aug-20 4:14 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel13-Aug-20 5:02
Otekpo Emmanuel13-Aug-20 5:02 
AnswerRe: MS SQL Database Bridge Pin
Richard Deeming13-Aug-20 4:18
mveRichard Deeming13-Aug-20 4:18 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel13-Aug-20 5:01
Otekpo Emmanuel13-Aug-20 5:01 
GeneralRe: MS SQL Database Bridge Pin
Otekpo Emmanuel14-Aug-20 5:19
Otekpo Emmanuel14-Aug-20 5:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.