|
My advice is never store multiple pieces of data in one column unless you absolutely can't avoid it. Systolic pressure and diastolic pressure are distinct pieces of data and should be recorded separately. Do you have a valid reason for avoiding the "traditional" way?
To show you why they should be stored separately here is part of a blood donation form. "Donors must have blood pressure values of 180 or less for the top (systolic) number and 100 or less for the bottom (diastolic) number. Donors with values greater than 140/90 may wish to consult their personal physician." So as you can see, the numbers for eligibility are different than the numbers where you should be concerned. Not only that, but the difference between the concern and max numbers is different for the two pieces of data. So if anyone ever wanted a report where the pressure was above the rate of concern, but below the maximum for donation that query would be much more difficult to write if you combined the data. You also couldn't do proper sorting.
|
|
|
|
|
well, i won't have issue saving it separately in the sql server but I don't want many controls on the form? so what's the best way to have some thing like a mask of 999/999 Left or 999/999 Right?
|
|
|
|
|
ALTER procedure Villas_proc_Insert_EnquiryBookingDetail
(@BId int ,@VId int,@FromDate datetime,@Todate datetime)
As
BEGIN TRAN AAA123
WHILE (@FromDate < @Todate)
BEGIN
insert into Villas_EnquiryBookingDetail(BId,VId,BookedDate)
values(@BId,@VId,@FromDate)
SET @FromDate = dateadd(day,1,@FromDate)
END
update Villas_Enquiry set status= 'Confirm' where BId= @BId
if @@error =0
BEGIN
COMMIT TRAN AAA123
END
ELSE
BEGIN
ROLLBACK TRAN AAA123
END<pre>
here VId +BookedDate are unique key in Villas_EnquiryBookingDetail table
exe Villas_proc_Insert_EnquiryBookingDetail 5,2,'03/02/2010','03/07/2010';
exe Villas_proc_Insert_EnquiryBookingDetail 5,2,'03/07/2010','03/10/2010'
how to roll back whole tran if Violation of UNIQUE KEY constraint hep pend
in my procedure
|
|
|
|
|
Use Try Catch block and in
catch block write statement rollback tran
this may work for you easily
|
|
|
|
|
I can't get the Total box to calculate. I am trying to create an online invoice for my customer to print from my webpage. I have scoured the internet looking for some help, but it doesn't help that I am clueless about javascript. This is what I have tried: In my table, all I want to happen is for the user to type in a price in the Amount boxes and then have a total at the bottom. Seems pretty basic, but I just don't understand why it won't work (not really sure of what I am doing)
Can somebody please help me?
The form itself can be found at www.ahtcsonline.com/invoice.html
Thank you in advance,
Evan
<script type="text/javascript">
function totalamountdue(){
{
var amount, amount2, amount3, amount4, amount5, amount6, amount7, amount8, amount9, amount10;
Amount = document.Invamt.Amount.value;
Amount2 = document.Invamt.Amount2.value;
Amount3 = document.Invamt.Amount3.value;
Amount4 = document.Invamt.Amount4.value;
Amount5 = document.Invamt.Amount5.value;
Amount6 = document.Invamt.Amount6.value;
Amount7 = document.Invamt.Amount7.value;
Amount8 = document.Invamt.Amount8.value;
Amount9 = document.Invamt.Amount9.value;
Amount10 = document.Invamt.Amount10.value;
Total = document.Invamt.Total.value;
document.Invamt.Total.value = (amount + amount2 + amount3 + amount4 + amount5 + amount6 + amount7 + amount8 + amount9 + amount10);
}
}
</script>
</head>
<table width="738" border="1">
<tr class="Title-centered">
<td width="214" align="left"><div align="center"><strong>Name of Attendee</strong></div></td>
<td width="229"><div align="center"><strong>Description</strong></div></td>
<td width="118"><div align="center"><strong>Amount</strong></div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name" type="text" class="Input_box" id="name" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class" class="Input_box" id="select_class">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount" type="text" class="Input_box" id="Amount" size="15" />
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name2" type="text" class="Input_box" id="name2" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class2" class="Input_box" id="select_class2">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount2" type="text" class="Input_box" id="Amount2" size="15" />
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name3" type="text" class="Input_box" id="name3" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class3" class="Input_box" id="select_class3">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount3" type="text" class="Input_box" id="Amount3" size="15" />
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name4" type="text" class="Input_box" id="name4" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class4" class="Input_box" id="select_class4">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount4" type="text" class="Input_box" id="Amount4" size="15" />
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name5" type="text" class="Input_box" id="name5" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class5" class="Input_box" id="select_class5">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount5" type="text" class="Input_box" id="Amount5" size="15" />
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name6" type="text" class="Input_box" id="name6" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class6" class="Input_box" id="select_class6">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount6" type="text" class="Input_box" id="Amount6" size="15" />
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name7" type="text" class="Input_box" id="name7" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class7" class="Input_box" id="select_class7">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount7" type="text" class="Input_box" id="Amount7" size="15" />
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name8" type="text" class="Input_box" id="name8" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class8" class="Input_box" id="select_class8">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount8" type="text" class="Input_box" id="Amount8" size="15" />
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name9" type="text" class="Input_box" id="name9" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class9" class="Input_box" id="select_class9">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount9" type="text" class="Input_box" id="Amount9" size="15" />
</div></td>
</tr>
<tr>
<td><div align="center"><span class="style15">
<input name="name10" type="text" class="Input_box" id="name10" size="40" />
</span></div></td>
<td><div align="center"><span class="style12">
<select name="select_class10" class="Input_box" id="select_class10">
<option selected="selected">--Select a Class-- </option>
<option>TRACS 202c</option>
<option>Special Claims</option>
<option>Enterprise Income Verification</option>
<option>Tenant File Management</option>
<option>Secure System</option>
<option>iMAX</option>
<option>Section 504 </option>
</select>
</span></div></td>
<td><div align="center">$
<input name="Amount10" type="text" class="Input_box" id="Amount10" size="15" />
</div></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td class="standard_label">Terms: NET 15 from class date</td>
<td><div align="right" class="Title"><strong>Total Amount Due</strong>:</div></td>
<td align="center">$
<input name="total" type="text" class="Input_box" id="total"size="15"> <input type="button" value="Calculate" onclick="totalamountdue();">
<br></tr>
</table>
|
|
|
|
|
The Web Development forum might be a better place for this.
|
|
|
|
|
Sorry for posting in the wrong area. I corrected this by post in the suggested area of Web Development. Thank you for correcting me.
Evan
|
|
|
|
|
Hi there,
I have a text field that I've stored a date pulled from a SQL Anywhere DB. It displays fine, the problem I'm having is writing the date back to the database from the same text field, I recieve the following exception message:
"iAnywhere.Data.SQLAnywhere.SAException: Cannot convert 1/1/1982 12:00:00 AM to a timestamp at ..."
The field that I'm trying to write back to in the SQL Anywhere database is of type 'Date'. Really I only want to write the date portion of the DateTime back to the database.
Hope you can help
|
|
|
|
|
| You need to put the date into a format that SQL recognises and can convert back to a proper DateTime type. I don't know about Anywhere DB but most systems would handle this OK. txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
Thanks for the feedback Richard. I understand that the problem is caused by the format of the data being passed back into the database. I have the format as yyyy-MM-dd as this is the format of the existing dates in the database so I know the filed accepts or should accept this format.
Has anyone ever used the built-in ASP.Net calendar to populate a text field and in turn a database date field? I think this is the way I'm going to go, with a button beside the text box to disply the calendar.
If you know of any examples or have tried it yourself I would be more than greatful for links etc.
Thanks
|
|
|
|
|
MWRivera wrote: I have the format as yyyy-MM-dd as this is the format of the existing dates in the database
Unless you are storing your dates as strings then this is not the case. Dates in databases should always be stored as DateTime types which is the UTC value of the date and time. It is only when you need to display them that the actual formatting takes place, when it should be in accordance with your regional settings.txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
Thanks guys.
Thanks I managed to get the date saved in the following format yyyy-MM-dd and when the field is empty I simply insert NULL into the date field, which is accepted with no exception thrown.
|
|
|
|
|
Hi
I am working in sql 2000 database and I want to retrieve a select statement and generate an xml. Everything goes perfect except the fact that I can't add a general root for the entire result from dhe generated xml. My code is like this:
SELECT FirstName , LastName
FROM Employees
FOR XML AUTO, ELEMENTS
and the result for this is
<Tab;e>
<Employees>
<FirstName>Nancy</FirstName>
<LastName>Davolio</LastName>
</Employees>
<Employees>
<FirstName>Andrew</FirstName>
<LastName>Fuller</LastName>
</Employees>
<Employees>
<FirstName>Janet</FirstName>
<LastName>Leverling</LastName>
</Employees>
<Employees>
<FirstName>Margaret</FirstName>
<LastName>Peacock</LastName>
</Employees>
but what I want is that this xml to look like this
<Table1>
<Employees>
<FirstName>Nancy</FirstName>
<LastName>Davolio</LastName>
</Employees>
<Employees>
<FirstName>Andrew</FirstName>
<LastName>Fuller</LastName>
</Employees>
<Employees>
<FirstName>Janet</FirstName>
<LastName>Leverling</LastName>
</Employees>
<Employees>
<FirstName>Margaret</FirstName>
<LastName>Peacock</LastName>
</Employees>
</Table1>
thanks for any advice.
p.s. I meantioning again that im workin in sql 2000Qendro
|
|
|
|
|
I use neither 2000 or xml but have you tried the following...
SELECT FirstName , LastName
FROM Table1.Employees
FOR XML AUTO, ELEMENTS
it seems logical, I have no idea if it will work!Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Isn't that what the OP had 
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Not quite, I added Table1. to employees. I was hoping the dot notation would work.
I note you gave him the correct answer so I learn something yet again!Never underestimate the power of human stupidity
RAH
|
|
|
|
|
It is totally illogical unless the Table employees exists in the Table1 schema; and why would you even have a schema called table1?
|
|
|
|
|
Take a look at the XML supplied by the OP, note the hierarchy of nodes, see where he added Table1 as the PARENT node to the employee records, it it not logical that the parent node may prefix the employee node when defining the location in the xml data.
SilimSayo wrote: unless the Table employees exists in the Table1 schema
Besides what has schema got to do with XML data?
SilimSayo wrote: and why would you even have a schema called table1?
Schema, what schema, who mentioned schema.
If you think a schema called table1 is dumb, hang around here for a while, you see some doozies in the forums.Never underestimate the power of human stupidity
RAH
|
|
|
|
|
If you were to use a fully qualified name when selecting from table employee, you would write
Select * from mydatabase.myschema.employee.
If you use a partially qualified name you would write:
Select * from myschema.employee
or
Select * from mydatabase..employee
So Table1.Employee is interpreted as a table called Employee in a schema called Table1.
|
|
|
|
|
 The OP is using XML. I know what a schema is I have been working with databases for 20+ years. What I have not worked with is XML and they are NOT the same thing. You're discussion about schema is totally irrelevant to the OPs question.Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I understand what you are saying but you're not getting my point at all. I am saying that the "compiler" would think that Table1 is a schema because it prefixes the table name employee. In other words, don't write Table1.employee because Table1 would understood differently by the "compiler". If you're worked for 20 years plus with a database, this should be pretty much common sense. I don't know much about how to generate XML but if do a little googling, you should be able to find the answer especially for someone with 20+ years in the IT industry.
|
|
|
|
|
SilimSayo wrote: but you're not getting my point at all
You are quite correct in that, I was only focusing on the question of the OP, not on a general discussion of how the SQL was going to interpret the statement.Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
I have a project which has been dormant for a year but was just fine when I last used it.
Now, one year on, with nothing changed, when I publish and install, it insists on re-installing SQL Server Express even though it is already installed.
No changes made to the bootstrapper, which used to work just fine ....
And just to add to the fun, the previous Dotfuscator stored settings also fail to obfuscate the code.
I could understand it if I'd been tinkering but this literally hasn't been touched since the last publish a year ago!
Cheers,
Rich
|
|
|
|
|
Oooh nasty
So your app has not changed, now it comes down to your environment, you know all those lovely security and product updates courtesy of every vendor with software on your platform, one (or more) of them has probably changed something.
I would think that rebuilding your install may make a difference. You may want to look at changing your references away from 'specific version'Never underestimate the power of human stupidity
RAH
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
