Added: May/24/2006 at 12:11am | IP Logged

Chris,

I have a problem adding more pictures, I changed the code below:

Set CmdEditAd = Server.CreateObject("ADODB.Recordset")
cmdTemp.CommandText = "SELECT Ads.* FROM Ads WHERE (Ad_ID = " & Ad_ID & ")"
cmdTemp.CommandType = 1
Set cmdTemp.ActiveConnection = ConnClassified
CmdEditAd.Open cmdTemp, , 0, 1

 Name = CmdEditAd("Name")
 Image1_Uploaded = CmdEditAd("Image1_Uploaded")
 Image1_FileExtension = CmdEditAd("Image1_FileExtension")
 Image2_Uploaded = CmdEditAd("Image2_Uploaded")
 Image2_FileExtension = CmdEditAd("Image2_FileExtension")
 Image3_Uploaded = CmdEditAd("Image3_Uploaded")
 Image3_FileExtension = CmdEditAd("Image3_FileExtension")
 Image4_Uploaded = CmdEditAd("Image4_Uploaded")
 Image4_FileExtension = CmdEditAd("Image4_FileExtension")
 Image5_Uploaded = CmdEditAd("Image5_Uploaded")
 Image5_FileExtension = CmdEditAd("Image5_FileExtension")
 Image6_Uploaded = CmdEditAd("Image6_Uploaded")
 Image6_FileExtension = CmdEditAd("Image6_FileExtension")
 Image7_Uploaded = CmdEditAd("Image7_Uploaded")
 Image7_FileExtension = CmdEditAd("Image7_FileExtension")
 Image8_Uploaded = CmdEditAd("Image8_Uploaded")
 Image8_FileExtension = CmdEditAd("Image8_FileExtension")
 Image9_Uploaded = CmdEditAd("Image9_Uploaded")
 Image9_FileExtension = CmdEditAd("Image9_FileExtension")
 Image10_Uploaded = CmdEditAd("Image10_Uploaded")
 Image10_FileExtension = CmdEditAd("Image10_FileExtension")
 Image11_Uploaded = CmdEditAd("Image11_Uploaded")
 Image11_FileExtension = CmdEditAd("Image11_FileExtension")
 Image12_Uploaded = CmdEditAd("Image12_Uploaded")
 Image12_FileExtension = CmdEditAd("Image12_FileExtension")

but I guess I need to also modify the database, and I can't open the access 2002 version using the tool I always use, stp admin,

Could you tell me how to add more pictures to your app?

they uploading fine, but show up as not uploaded, and pop up below the upload menu, which is fine, but I bet the front end will not
show them properly either unless I remove database check and only go by file check...

Is there a better way? simply adding options for them to database?

thanks!