Hi All, I'm creating a survey form whose data needs to be store in database. I'm using ASP and MYSQL for this. My form page is working fine, I mean Javascript....
I am trying to run a stored procedure on SQL Server. Here is the procedure: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[vb_get_name] ...
Only thing I see is I think you need to define the param as input-output, not just output. Most queries don't need the output param to get results like this,...
Please help! At this point I'm banging my head against the wall!! The web address to the contact form is http://www.thevilla-austin.com/contactus.html The...
You just need to htmlencode the lines to display code: response.write HTMLEncode(thisline) & "<br>" I've noticed having to use replace() for some things to...
Add in some tracing code, write those to the screen, this will let you know if the email got to the server OK or not, the message object has .TimeSent which...
Dear All, I have a table 'branch' with two fields: 1. branch_code 2. branch_name I have a page where I have a combo box with all branch codes. I want to show...
I'm going to assume this is a dropdownlist since there is no native combobox for the web ;) Is the user making the selection, or are you pulling it from...
Thanks Peter, But how to submit the dropdownlist value on the same page? Do I have to write the function in vbscript? Sarfraz ________________________________ ...
Classification: UNCLASSIFIED Caveats: NONE Good Morning: I have been all over the Internet but cannot find out if it is possible to nest several SELECT COUNT...
Classification: UNCLASSIFIED Caveats: NONE I have nine columns, 300 rows, and I'm trying to count how many times the word 'beef' appears in those nine...
If you don't want to use Javascript, then you'll need a submit button for the form... or I suppose you could use client-side VBScript. ... [Non-text portions...
I'm lazy, so would get the recordset w/300 rows, you flip through that a row at a time and for each of those you flip through the columns, but there's a lot to...
I would say that union is the fastest way to go here: Select count (columnname) from tablename where columnname like '%beef%' Union Select count (columnname2)...
You might get away with this: Select sum(counter) as totalcounter from ( Select count (columnname) as counter from tablename where columnname like '%beef%' ...
Thought he was trying to check the "text" within those columns ... seems to me select count(*) union select count(*) will work, I like loops better as a...
Basically I need to count realtime how many and what type of meals are ordered for a banquet. The Select Count Union Works well, but I'd sure like to be able...
That's easy, declare a variable for each total for each part of the union, then add a "select @Total = @Total1 + @Total2 ..." at the end to pass it back. tom...
Wold the variable be inm the for of Union=? I'm pretty new at this advanced stuff SMS Jack Gruber NCC California National Guard 916-854-3560 ... Sent from my...
declare @Total1 int declare @Total2 int ... declare @TotalN int --find the totals however you do it, my sense is it needs to be done row by row so I recommend...
Hi!! i want to validate a list box onthe onblur event and if no value is selected , display a message on the left using <span> and innerHTML here's what i have...
Hi I'm using cdo component in my asp page. I'm sending email to the client in html format. some client's received correct format and some clients received...
First, I would suggest passing a reference to the list to make the method more extensible, i.e. onblur="validateCB(this)" Now to the real problem here. The...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
