Search results for query: *

I use the following SQL statement coded in ASP to delete a record from a SQL server database: It deletes the record based on a dropdown menu which send the Business_ID. SQL = "DELETE FROM Business" SQL = SQL & " WHERE [Business_ID]='" & str_delete & "'" I also want to delete an image that...

I have the following code, which inserts into a database a record with a primary key named System_ID. For i = 0 to Ubound(val) if len(val(i))=2 then str_SQL = "INSERT INTO System ([BusinessID], [System Code], [System Description])" str_SQL = str_SQL & " VALUES " str_SQL = str_SQL & "('" &...

I have a text box on my page that calls a record field from an SQL database like so: <textarea name="EditText" cols="60" rows="5" id="EditText"><% Response.Write obj_RS1("Notes") %></textarea> The field Notes data type is varchar(8000) When I add an ' (apostrophe) into the text box and...

I have the following function that replaces part of a string so that the following: AA – Test – AA Becomes: Test – AA function Add () { var selObj = document.getElementById('Test1'); var txtObj = document.getElementById('Test2'); var selIndex = selObj.selectedIndex...

I have the following code that I am using to try to only allow access to a page to users with a certain IP address. [code] <% Select Case Request.ServerVariables("remote_addr") Case "ip address" Case Else Response.Redirect "http://www.google.co.uk/" Response.End End Select %> This doesn't...

I have a form where I select from a dropdown then add a two digit code to a input box then press submit. The submit then fires the form to a page which updates a SQL 2008 database table with the one record. What I'd like to do is be able to add more than one "two digit code" to the input box...

I have the following sql statement in ASP: sql = "UPDATE [System_Terms] SET " sql = sql & "[Terms Text]='" & Request.Form("EditTermsText") & "'" sql = sql & " WHERE [SystemID] = '" & id & "'" Basically this works perfectly when a record exists, can this be easily tweaked to INSERT as well if...

I am using AJAX to insert, update and delete to and from a database. My problem is it doesn't always work sometimes it does and sometimes it doesn't. When I just post the form data my database is always updated so there no problem at that end. Here is my AJAX, can anyone help me? function...

I have a System_PDF table and a System table. The System_PDF table allows more than one entry to be associated with the System table with the join being on the System.System_ID and System_PDF.SystemID. My problem is when I show a list of records from the System table - any record with more than...

I am using a sql database and storing images on there. Logos Logo_ID | Logo data I appear to be able to upload as the column is showing <Binary data> My problem is I am not able to view the images. If I wanted to view them in a list, I would have expected something like this? <% sql =...

I have the following sql statement: <% Dim id id=Request.QueryString("id") SQL = "SELECT * FROM System WHERE System.[System Code] = '" & id & "'" Set rs = obj_CN.Execute(SQL, adBoolean) %> I need to join four tables instead of having just one. System System_ID(PK) | System Code | System...

I have two database tables. The link between the two is the Business.UnitID and Unit.Unit_ID. Business: Business_ID | Business Code | Business Description | UnitID | LogoID Unit: Unit_ID | Unit Code | Unit Description At the moment on my page I have a drop-down menu that only lists...

I have the following tables: System: System_ID | System Code | System Description | BusinessID | Business: Business_ID | Business Code | Business Description | ModuleID The join here would be between the System.BusinessID and the Business.Business_ID. On my page I initially...

I am editing records from a SQL database using a form in ASP. The form posts to a new page <form method="post" action="edit_Business.asp"> which contains the following: <% sql="UPDATE Business SET " sql=sql & "[Business Code]='" & Request.Form("BusinessCode") & "'," sql=sql &...

I am adding a new record to a table name System. At the moment I am selecting a value from a dropdown list (populated by the BusinessID value from a database)and adding a value to a text box. BusinessID is linked to the System table, which is the table that I’m adding to. This works...

First of all not sure if this is in the correct forum as I think it could qualify as ASP or SQL. I’m displaying records on a web page that I get from an SQL database. I want to highlight a record that has a field missing. So for example if I have five columns and any one of the columns has a...

I am currently displaying a list of ‘system codes’ which are grouped by a ‘unit code’ on an ASP webpage I want to be able to manually add a ‘system code’. I have a form that contains two dropdowns (1) that contains unit codes (2) contains business codes - these are populated by the database. I...

I have the following tables: Unit Unit ID Unit code Unit description System System ID System code System description Business ID ~ Joined to Business table Cover ID ~ Joined to Cover table Business Business ID Business code Business description Unit ID ~ Joined to Unit table Logo ID ~ Joined...

I want to be able to display the first 3 offers from an rss feed. For example, something similar to this one: http://www.offers.co.uk/rss/food-drink I don’t want to use an external site or link to display the 3 offers, does anyone know of any examples for this? My pages use classic ASP. I...

I have a form that generates a link. A user selects an option from a dropdown menu then via a javascript function a link is created in a textarea box. I would like to add a text box to the form so a user has an option to add their own text if they don’t want to use the dropdown menu. Here is...