Gossamer Forum
Home : Products : DBMan SQL : Discussion :

SQL problems

Quote Reply
SQL problems
I have four questions regarding the SBMan SQL:

1. I have a lot of pictures. I want to set up a system such that 'agents' can use a drop down menu with titles of pictures on the server. Once selected the picture will be placed in the dynamically presented pages. Is there a way I can do this?

What I have done so far is this:

I have create a new image field (with Column Type = Char(255)) by choosing Form Type = FILE in Form Information and File Save Location. Also set auth_modify_own to Yes in setup. I have added the code <img src="db.cgi?cn=PicOne&do=view_file&db=<%db%>&id=<%primary_key_field%>"> in my templates.
"PicOne" is the name of the column name.

What is the code I need to add to the add-form page? Have I done this right so far? Please provide steps I need to follow.

2. If the agent wants to upload their own pictures what do I put in the add-form html page?

3. I am going to have a lot of check boxes in both search page and add-form page. I have created the columns but need the code for the templates.

I have a column called "Interest" and it has the check boxes Alpine, Beachfront, CapitalCity, Island, Lakeside etc.

In the search page html template what do i put as the code? Is this correct:

<input type="checkbox" name="Alpine" value="Alpine"></font>

In the add-form html template do I use the same code?

4. I have created a column for email and web address. When the agent adds this info and then search the agents email and web address is presented. I know how to make the email and web address display but I don't know how to also make them hyperlinked such that if one clicks on the web address it takes you there. Can you please supply the code?

Thanks for your help!
Subject Author Views Date
Thread SQL problems needsupport 3549 Feb 3, 2002, 9:35 PM
Thread Re: [needsupport] SQL problems
604 3437 Feb 4, 2002, 11:10 AM
Thread Re: [TheStone] SQL problems
needsupport 3429 Feb 4, 2002, 3:12 PM
Thread Re: [needsupport] SQL problems
604 3438 Feb 4, 2002, 3:42 PM
Thread Re: [TheStone] SQL problems
needsupport 3412 Feb 4, 2002, 4:04 PM
Thread Re: [needsupport] SQL problems
604 3403 Feb 4, 2002, 4:37 PM
Post Re: [TheStone] SQL problems
needsupport 3399 Feb 4, 2002, 4:45 PM
Thread Re: [TheStone] SQL problems
needsupport 3374 Feb 4, 2002, 5:09 PM
Thread Post deleted by TheStone
604 3409 Feb 4, 2002, 5:15 PM
Post Re: [TheStone] SQL problems
needsupport 3393 Feb 4, 2002, 5:21 PM