scripto
Last Activity: Mar 24 '08, 07:59 PM
Joined: Oct 9 '06
Location:
-
prod_price should be AT LEAST decimal(4,2) -
try this
if (radiolist[3].checked==true)
{
for (var j=0; j<checklist.len ght; j++)
{
checklist[j].checked=true;Leave a comment:
-
I am assuming "in front of" means "before" today's date - yes?
[CODE=javascript]if (CheckDate(form .arrivaldate.va lue) == false) {
alert( "Please make sure your arrival date is at least 2 days in front of today's date" );
form.arrivaldat e.focus();
return false ;
}
[/CODE]
[CODE=vb]<script language=vbscri pt>
function CheckDate(sDate )...Leave a comment:
-
here is a quick solution - we could add error checking between deletes
create procedure dbo.usp_DeleteR ecords
@id_to_delete int
as
delete from [dbo].[tblGroup]
where [groupID] = @id_to_delete
delete from [dbo].[tblProfile]
where [subGroupID] in (select [subGroupID] from [dbo].[tblSubGroup]
where [GroupID] = @id_to_delete)
delete from...Leave a comment:
-
for every occurance replace
.style.visibili ty = "";
with
.style.visibili ty = "visible";Leave a comment:
-
try this
SELECT (columns desired)
FROM recipient p
JOIN requests r ON p.recipient_id= r.recipient_id
JOIN incident i ON r.request_id=i. request_id
left outer JOIN actions a ON a.request_id=i. request_id
JOIN users u ON a.user_id=u.use r_id
WHERE manager_id='val ue' AND status_code = 1Leave a comment:
-
one possibility could be if the web application is starting a process but never quite completing it - so now Sql server has to wait until the app is finished processing the previous call before continuing...th e problem may be in the web application and not with your stored procs.Leave a comment:
-
well, if your db.sales_month table has the dates you need, then try a Left Outer join. Let me/us know how it goes.Leave a comment:
-
if there is no entry for a specific day or days in the db.sales_dates table then you will not get a null value or a 0. You would need to create another join on another table (like tblSeptember) where those dates exist, then you can get all the nulls for dates in September.Leave a comment:
-
try this
var strSQL1="select Model from Phones as p1 where Brand='"+ brand +"'";
var strSQL2="select Model from Phones as p2 where Model='"+ model +"'";
var strSQL3="select Model from Phones as p3 where Camera='"+ camera +"'";Leave a comment:
-
SELECT COUNT(*) AS Expr1
FROM db.sales_month RIGHT OUTER JOIN
db.sales_dates ON (dbo.sales_mont h.full_date = db.sales_dates.[Date] AND
db.sales_month. prod_name = 'Chairs')
GROUP BY db.sales_month. full_date
ORDER BY db.sales_month. full_dateLeave a comment:
-
scripto replied to getting the id of dynamically generated textboxes in using document.getElementById()in JavascriptI would try
id='row' + id.toString();
the problem is that getElementById only accepts strings, so convert the ID to a string first.Leave a comment:
-
change this
mySQL = " SELECT * FROM [banner] WHERE banner_postnr= '" & strfirst & "', banner_gender ='" & strgender & "'"
to
mySQL = " SELECT * FROM [banner] WHERE banner_postnr= '" & strfirst & "' and banner_gender ='" & strgender & "'"Leave a comment:
-
if your role is db_owner then
CREATE TABLE dbo.tablename
( .....)
if you only have permission to create tables then you cannot create a table as dboLeave a comment:
-
That is a browser setting.
In IE, click on properties, content and under AutoComplete, click Settings and uncheck everything. Click Ok, Ok and that should do it.Leave a comment:
-
try "window.locatio n.href='uploadN um.asp?upNum=1' ;"...Leave a comment:
-
"WHERE [FFField Name] LIKE '*" & txtFieldName & "*' OR " & _
"[Field Description] LIKE '*" & txtDescription & "*'"
Set mRS = mDB.OpenRecords et(Sql, dbOpenSnapshot, dbFailOnError)
both fields should work the same way - unless you have an apostrophy (or any special chars) in your txtDescription field.Leave a comment:
-
The only way - so far - is to use this html line of code for EACH file:
<INPUT TYPE=FILE SIZE=60 NAME="FILE1">
so you will need to process the upload routine for each <INPUT>Leave a comment:
-
well what's the error message?...Leave a comment:
-
here you go
SQL = "SELECT LWFieldKey, LWTableLink, LWTableName, [LWFieldName_4], [Field Description] " & _
"FROM LWTABLES INNER JOIN LWFIELDS ON " & _
"LWTABLES.LWTab leKey = LWFIELDS.LWTabl eLink " & _
"WHERE [LWFieldName_4] like '%" & txtlwField & "%' OR " & _
"[Field Description] like '%" & txtlwDescriptio n & &q...Leave a comment:
No activity results to display
Leave a comment: