Viewing 15 posts - 196 through 210 (of 251 total)
Hmmm, how many times did you post this one?
Tim C.
//Will write code for food
One Windows to rule them all, One Windows to find them,
One Windows to bring them all...
January 21, 2003 at 11:45 am
To answer your question the table variable must be decalred inside the dynamic sql. But there is a problem, getting that table variable back out. AFAIK the only way you...
January 21, 2003 at 9:00 am
Sounds like you want a check constraint more than a unique constraint. You just don't want them entering the same entry twice, but the field can contain nulls? In that...
January 21, 2003 at 8:46 am
Example for #1 :
<html>
<head>
<title>Foo</title>
</head>
<body>
<TABLE id="Table1" cellSpacing="0" cellPadding="0" align="center" border="0">
<TR>
<TD noWrap align="left">This is some arbitrary text for column 1</TD>
<TD noWrap align="left"><SELECT ID="Select1" NAME="Select1">
<OPTION value="1">Value 1</OPTION>
<OPTION value="2">Value 2...
January 21, 2003 at 8:39 am
2 suggestions :
1) Put all of the elements in your page into a hidden table. That way the combo
boxes, text boxes width won't matter. Everything will be align-able using...
January 21, 2003 at 8:28 am
Thx Pete, What I was asking for was a way to use the CASE in the FOR clause, which I don't think is allowed. I am aware of out to...
January 21, 2003 at 8:23 am
quote:
I found an interesting post that relates to this subject at http://www.pinnaclepublishing.com/SQ/SQmag.nsf/0/69091C0DC2E8E996852568E7006CB9A3From that article :
INSERT...
January 20, 2003 at 10:54 am
I found an interesting post that relates to this subject at http://www.pinnaclepublishing.com/SQ/SQmag.nsf/0/69091C0DC2E8E996852568E7006CB9A3
From that article :
INSERT INTO customer (CustID, CustName) ...
January 16, 2003 at 5:28 pm
quote:
I believe it means SELECT..INTO..FROM
I do not wish to create a new table as...
January 16, 2003 at 5:17 pm
Nice interesting solution to my question. How could it be done without a temp
table, or cursor though? I usually resort to those as a LAST resort. I can not...
January 16, 2003 at 5:05 pm
Micheal did you get my zipped project with the example of binary comparisons? I can post it on my web site for download if you want me to.
Tim C.
//Will write...
January 16, 2003 at 9:45 am
quote:
- simple ASP/VB-code rules out OR-ing and AND-ing
The OR and AND in ASP...
January 16, 2003 at 8:17 am
I think it mightbe that you are returning a table type that returns more than one row, and you are tyring to stuff it into that one row, and yes...
January 15, 2003 at 5:29 pm
Oops forgot the controls that go onto the form. Add a checkbox, and 2 command buttons. Then set the properties for everything to the below settings. In particular the index...
January 15, 2003 at 1:37 pm
You're quite correct Brian, my solution is only good for about 31 answers to one
group. And at that time Antares is absolutely correct I would have to switch to...
January 15, 2003 at 1:31 pm
Viewing 15 posts - 196 through 210 (of 251 total)