Click here to Skip to main content
15,033,627 members
Home / Discussions / Database
   

Database

 
QuestionDatabase ADO exception on adding new record Pin
Peter Mortier16-Oct-20 4:21
MemberPeter Mortier16-Oct-20 4:21 
GeneralRe: Database ADO exception on adding new record Pin
Richard MacCutchan16-Oct-20 4:53
mveRichard MacCutchan16-Oct-20 4:53 
AnswerRe: Database ADO exception on adding new record Pin
CHill6016-Oct-20 5:18
mveCHill6016-Oct-20 5:18 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 1:58
MemberPeter Mortier19-Oct-20 1:58 
AnswerRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 2:00
MemberPeter Mortier19-Oct-20 2:00 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov19-Oct-20 7:07
MemberVictor Nijegorodov19-Oct-20 7:07 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier20-Oct-20 8:40
MemberPeter Mortier20-Oct-20 8:40 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov20-Oct-20 9:29
MemberVictor Nijegorodov20-Oct-20 9:29 
QuestionDatabase design and custom query for this use case ? Pin
karengsh13-Oct-20 23:17
Memberkarengsh13-Oct-20 23:17 
QuestionShould I store files in a database? Pin
Member 1260015012-Oct-20 22:37
MemberMember 1260015012-Oct-20 22:37 
AnswerRe: Should I store files in a database? Pin
Richard Deeming12-Oct-20 22:54
mveRichard Deeming12-Oct-20 22:54 
QuestionMYSQL Pin
Member 147129666-Oct-20 10:21
MemberMember 147129666-Oct-20 10:21 
AnswerRe: MYSQL Pin
ZurdoDev6-Oct-20 10:34
professionalZurdoDev6-Oct-20 10:34 
QuestionDatabase scripts version control process/strategy? Pin
Member 1363071429-Sep-20 6:06
MemberMember 1363071429-Sep-20 6:06 
AnswerRe: Database scripts version control process/strategy? Pin
David Mujica29-Sep-20 7:48
MemberDavid Mujica29-Sep-20 7:48 
AnswerRe: Database scripts version control process/strategy? Pin
ZurdoDev29-Sep-20 9:05
professionalZurdoDev29-Sep-20 9:05 
QuestionSimple Database design Pin
fdanos23-Sep-20 20:23
professionalfdanos23-Sep-20 20:23 
AnswerRe: Simple Database design Pin
Victor Nijegorodov23-Sep-20 20:54
MemberVictor Nijegorodov23-Sep-20 20:54 
AnswerRe: Simple Database design Pin
Mycroft Holmes24-Sep-20 12:18
professionalMycroft Holmes24-Sep-20 12:18 
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
Memberrodgerm25-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:

<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:

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 

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.