Search results for query: *

Thanks, actually answered 2 of my questions in 1! Cheers guys!

I need to create a page that uses something similar to layers to display content from a db when a link is clicked. I shall try to explain in a bit more detail. There will be a text link advertising something and when the user clicks the link i need some other text, from the db, to be displayed...

Cheers, that worked - uploaded it to the web server and it worked Thanks!

its an access db - i havent set any permissions on the database.

It didnt work! productID is numeric. There is nothing wrong with the variable - it just doesnt seem to like the statement. It doesnt seem to have the power to modify the database? IS there any setting within the database?

I am getting the following message: Error Type: Microsoft JET Database Engine (0x80004005) Could not delete from specified tables. /admin_delrecord_saved.asp, line 22 My code is as follows: <% delid = Request.Form("delid"); conn=Server.CreateObject("ADODB.Connection")...

I'm using it in the context of ASP connecting to an Access database. Thanks!

Can anyone advise me on how to correct this apparent syntax error? add = "INSERT INTO tblProducts (Name,Description,Category,Keywords,ImagePath,Price) VALUES ('"+name+"','"+description+"','"+category+"','"+keywords+"','images/"+image+"',"+price+")"; Cheers, Fatmbk

I think i misunderstood what i wrote! I need to get rid of the 2 ' ' at the beginning and end of this: <OPTION value='"(((tblCategory.Category)=Keyboard))"'>Keyboard</OPTION> How do i do this because i havent put the 2 ' ' in the Javascript code?

I have the following code (JavaScript): Response.Write("<option value=&quot;(((tblCategory.Category)="+rs(x)+"))&quot;>"+rs(x)+"</option>"); Basically, it puts a query string into a HTML form <option> tag when the page is run. This is required to make the drop down box dynamic. However, its...

Hi, I think it's a relitivly simple question but does anyone know how to get data from 1 coloumn of an Access database table into a drop down menu in a form? Cheers, Fatmbk

I have read about SSI (Server Side Includes) and I want to know how i can use them. Am i right in thinking that they enable a programmer to write a block of code and then store it within an include file, then that include file is included in any pages you require that code in? My overall aim...

Yes! you need to change the target of the hyperlink. Within the hyperlink itself you need to add target="" and within the two speech marks (") type the name of the target page e.g. _self, _parent, _blank, or your own page. Hope that helps - post your code if it doesn't. Cheers, Fatmbk

Yes - i'll try again at explaining it a bit better! I have a database with a list of email addresses stored in it. I want to be able to send an email, using CDONTS, to all the email addresses stored within the database. I need to know how to get this list of email addresses into the...

that is in effect what i need to be able to do. Basically it is for an admin section for sending out a weekly email to a list of email address in a database. I need to pass all the email address from the database into objCDO.Bcc. My thoughts were to create a variable to store the email...

I am currently implemeting an ASP page that requires me to read data from 1 field in an MS access database and then put the value's that it gets into a variable. Any ideas on how to do this? Cheers, Fatmbk

I need to design a simple but secure login form. What is the simplist, but secure way of doing this. Many Thanks, Fatmbk

Thanks for all your input. I do agree with the last post - perhaps it isn't properly normalised. The database is for a computer business that usually has maybe 200 - 300 items of stock. As i think about it now, maybe i should have used something which had the stock details in and then had a...

Thanks - that makes sense now - one question: How do you requery? Thanks.

I am currently building an order processing system using MS Access 2000. I have hit a problem - I need to be able to change the data in one field of the open record when the user goes onto the next record. i can't work out how to do it. i would appriciate it if someone could point me in the...