I thought id put this here as I dont know asp and only use it through dmx for now. I can ssi in a ASP page but is there a way of storing the ssi script in a database and calling it up dynamicaly as part of a search?

hope i explained ok

regards andy
<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

You can have page1.asp be your normal page. Page2.asp can be included into page1.asp and have page2.asp look up the database and display its results on the page. Since it is included on page1.asp you are calling the information up dynamically.

That make sense?

Not sure if I understand exactly what you are looking for.

Dave

_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2

what i was hoping to do is after the user searches the database a list of results is shown and when the user clicks on any link they are taken to display.asp?id=1 (or whaterver id number is required) and the information on this page is an ssi stored in the database. i hears u cant ssi in an asp page from a databse so i think im goona have to create a page for each result.

I am confused about exactly what you are trying to do here. Can you explain in detail?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
what i was hoping to do is after the user searches the database a list of results is shown and when the user clicks on any link they are taken to display.asp?id=1 (or whaterver id number is required) and the information on this page is an ssi stored in the database. i hears u cant ssi in an asp page from a databse so i think im goona have to create a page for each result.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2

Why does it need to be an SSI, it sounds to me like all you want to do is have a master/detail page.
And then all your info can be stored in a DB, and called whenever you like.

SSI's should really only contain some important code or message that you would like including/displaying on numerous pages. For example you could store a long list of variables in myInclude.inc, your dates and stuff in myDates.inc and finally your copyright info in myFooter.inc
If your DB is built right then searching it should not be a problem.

"Get the kettle on, time for a brew"

the reason I wanted to ssi was because I have been using an access Database which has a max field lenghth of 255 characters and the info i need is bigger, I am considering using a mysql database to store the information. what do you think?

regards andy <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
p.s. yes if you already havent guessed I am a newbie.

In access... set the field type to 'memo' and that will hold 65,000 characters.



_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2

cheers beano that'll do the trick. I really should know that as I trained as a Database devleloper, but still sorted now. I'm really glad I found this forum else Id have probably gone back to html and lots of editing.

regards Andy

Andy,

We have all been there. The lads here are great for help. When I was starting out they gave me a lot of advice on stuff I think is basic now. I was well impressed with LEED and OEASTWICK help. They are cool with their help. Many thanks to them. I am sure they'll help you out as well. Any problems you got, through them up. Someone will know the solution.

Best of luck.

Dave

_________________________
David Behan - www.site-manager.com/af.asp?a=11&l=1tds9p6x2