navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

RE: Match the Face to the Place!

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> RE: Match the Face to the Place! 		Page: <<   < prev  1 [2]
 
walrus

 

Posts: 545
Joined: 3/13/2003
From: London
Status: offline

  		RE: Match the Face to the Place! - 4/6/2003 3:16:13   
Done that but no joy. Same error message ..line 22

_____________________________

I hope The Boss isn't reading this, ...she thinks I program everything!

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Match the Face to the Place! - 4/6/2003 14:18:11   
Try changing the connection line to OLEDB as below :

objConn.Open " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath(" fpdb\results.mdb" )

(Where " results.mdb" is the name of your DB)
It is an access 2000+ database?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to walrus)
walrus

 

Posts: 545
Joined: 3/13/2003
From: London
Status: offline

  		RE: Match the Face to the Place! - 4/6/2003 15:46:17   
Sorry Spooky, I had one of those working too late, going cross eyed, can' t see any more moments. Like the guy with the flashing red light problem in that film....Andromeda something... anyway it works:). It was the OLE field that I missed. :)So I' ve stuck with 
objConn.Open Application(" helpme1_ConnectionString" )

It is Access 2000.
Are we just using the save to database method or are we still combining the two methods (save to file)?
I haven' t got a clue what to do now. The fields are saved but in a way Im not familiar with. I hope you will continue to guide me (like how to display the images)
Thanks for all your help so far. I have learnt about five or six procedures in this one thread alone.

_____________________________

I hope The Boss isn't reading this, ...she thinks I program everything!

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Match the Face to the Place! - 4/6/2003 17:44:36   
Ahh we are getting somewhere now :)
What we are doing, is combining the 2 methods.

You are saving all of your form results to database and you are saving a text reference to the file (which is saved in the /fpdb directory)

Then, when you query the database, you get the full record and image path that you can use to show the image. (you can continue using the DRW for that)

If you check your tests so far, youll see the image was saved to the fpdb folder too.

As for your next steps, you will add a new form field to the posting page and for each one of those, add a resulting database submission in the 2nd page

eg add a new line :

objRs.Fields(" DatabaseColumnName" ).Value = objUpload.Fields(" TextBoxName" ).value

Do this for all fields of information the user inputs


_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to walrus)
walrus

 

Posts: 545
Joined: 3/13/2003
From: London
Status: offline

  		RE: Match the Face to the Place! - 4/11/2003 3:35:29   
Excellent! Had some minor hitches, but I managed to get all the fields in. Im going to fiddle around with YES/NO fields and stuff. Thanks Spooky. Are we finished or is there more to sort out?

_____________________________

I hope The Boss isn't reading this, ...she thinks I program everything!

(in reply to Spooky)
Spooky

 

Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline

  		RE: Match the Face to the Place! - 4/11/2003 4:43:30   
If it all works and submits to database and you can fetch and display the records, then by jove, I think weve finished :)

That was your first intensive asp experience. Was it good for you? [:p]


< Message edited by Spooky -- 4/11/2003 4:44 AM >

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)k¥


(in reply to walrus)
walrus

 

Posts: 545
Joined: 3/13/2003
From: London
Status: offline

  		RE: Match the Face to the Place! - 4/11/2003 14:17:04   
Thanks for all your help. I just didn' t know where to start. The only thing which is not yet incorporated is the session-user fields. Hopefully I' ll work it out though.
Many thanks!


_____________________________

I hope The Boss isn't reading this, ...she thinks I program everything!

(in reply to Spooky)
Page:   <<   < prev  1 [2]

All Forums >> Web Development >> ASP and Database >> RE: Match the Face to the Place! 		Page: <<   < prev  1 [2]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Back to top

  Microsoft Corporation in no way endorses or is affiliated with "OutFront."
  OutFront is published and edited by Thomas Brunt.
  440 Great Circle Dr., St. Matthews, SC 29135.
  © 2008 All Rights Reserved
  Click here to view our privacy statement.