Search results for query: *

How do I trigger the following SQL statement from a graphic 'update' button on an ASP page UPDATE addressbook INNER JOIN newaddress ON addressbook.PersonID = newaddress.PersonID SET newaddress.add1 = addressbook.add1 Any ideas ? Cheers chaps

How do I post a form to 2 different pages i.e. on submit go to 1.asp and 2.asp cheers

Is there a way of moving a field from one table to another ? i.e. (in short) Table 1= surname, telephone, address Table 2=email,firstname I want to move all the 'firstname' field contents from table 2 ( 11,000 records)into table 1 but aligned to the right surname etc. They have a common field...

How do i make a dropdown box populated from a MS Access database.Ive searched the faqs etc but have not found an answer i can work with. The first dropdown would show a straight list from a table 'Select CourseID, from Coureslist', Making a selection in this box would then get the details...

How do i make a dropdown box populated from a MS Access database.Ive searched the faqs etc but have not found an answer i can work with. The first dropdown would show a straight list from a table 'Select CourseID, from Coureslist', Making a selection in this box would then get the details...

I need to write a query looking for a date in say 'date1' in table named availability. BUT i would like the result showing '+' or '-' 2 weeks either side Any ideas ?

I have the following query (used on an ASP page) ------------ SELECT * FROM volunteer WHERE qualification='qual' AND AvailabilitYFrom1=#aval# --------------- The 'AvailabilitYFrom1' is a date. I want to return the date with + and - 7 days either side of it. Any body help ??

I have the following code and want to format the output text with a CSS style called 'whitetextsml'. Can anybody help ? CODE------ <script language="JavaScript"> <!-- var stb_domain = "igd.uk.com" var stb_user = "office" var stb_recipient = stb_user + "@" + stb_domain var stb_url = "mailto:" +...

Ref: http://www.igd.uk.com/plants/1dracaena.asp Please go to the above link to see problem. I have a problem with the final record, in the record set, displaying the detail text under the picture.It only seems to happen when there are not two records displaying next to each other.When you click...

I have the following code, but cannot seem to format the font that it displays. Whole code with script in it. <table width="999" height="74" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="340" background="images/homebotoomleft_14.gif"><table width="340" border="0"...

I want to make the "pic" the hyper link to detail.asp instead of the "name" - I cannot seem to get the syntax to work - can anybody help .... Full Code --------- <% CONST COL_COUNT = 2 If Not abc.EOF Then abc.MoveFirst col_ctr = 0 'not really necessary sec_row = "" Response.Write...

I have the following error................... Syntax error (missing operator) in query expression 'name = Generated by the following code ............. sec_row = sec_row & "<td align=left valign=top ><a class=greendata href='detail.asp?name=" & abc("name") & "'>" & abc("name") & " </a></td>"...

How do I display a result set in, say, 3 colums and as many rows as it takes to show the complete set ? There are not many items in the database - 12. Cheers

I have a result set displayed on a page and would like to click on the individual items and have the details displayed on the same page next to the main results and be able to do this with each item - there will only be 6 or 7. Will it have to be in a frame or is there any other way of doing it...

Problem: I want to check the contents of "table2, field 2" with that of "table1, field1" - basically im checking input in memo field in table 2 against a list of abusive terms in table 1. Is there an easy way of doing this (im a novice)

Im building a registration page. The username and password box enters info into my access database - how do i check to see if a nedw username is already in there - and how would i tell the page that that username is already in there.... cheers

I’m trying to check the contents of an one field in an Input form that updates my access database. The input form that it want to check field is free text and I want to check this against an abusive terms table in the same database. The abusive terms are just a list of swear words - one in each...

I have the following code but as Im a new to this im getting a bit mixed up. Will the following code get the image from my database, the image is held in a table field name of "picname" Any ideas ... <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr>...

Im trying to get results using the INNER JOIN in SQL below – but it just errors all the time – code ( as you can see dreamweaver produced the code) – Im a beginner <% Dim mem_detail Dim mem_detail_numRows Set mem_detail = Server.CreateObject(&quot;ADODB.Recordset&quot;)...

I would like to populate a table from a list selection box. I would like the user to use the drop down box to make a selection which then returns the data to the same table on the same page - does that make sense ... cheers