Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ernie57
Starting Member
27 Posts |
 Posted - 2007-03-18 : 11:25:14
|
More then two years ago I had a form in .asp created using Frontpage. When a user input information that didn't meet the requirement in SQL (sbs 2000) an error would be display after for form was submitted. I was playing around with the Diagrams in SQL server enterprise which I believe I created relationships that might have made the reporting error's possible, but I am not sure. Does anyone who if making these relationships could made the error's show up at the browser when someone is submitting a form?Ernie |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-18 : 16:48:08
|
| What is the error you are getting?MohammedU |
 |
|
|
Ernie57
Starting Member
27 Posts |
Posted - 2007-03-18 : 18:51:33
|
quote:
Originally posted by MohammedU
What is the error you are getting?MohammedU
Any kind of error! What I mean is if the data being entered is violating the constraints that are on the table an error is generated. Say phone number should be 555-555-5555, and some puts 123, and error should be generated or enters letter instead of number because it's looking for an integer. |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2007-03-18 : 19:11:45
|
| "Playing around with diagrams"You should get a grasp of constraints.If they show up in the browser (and how) depends on the application programming.rockmoose |
|
|
|
Ernie57
Starting Member
27 Posts |
Posted - 2007-03-18 : 19:25:22
|
quote:
Originally posted by rockmoose
"Playing around with diagrams"You should get a grasp of constraints.If they show up in the browser (and how) depends on the application programming.rockmoose
I don't know how I did it, but thank you anyway!Ernie |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2007-03-18 : 19:33:13
|
quote:
Originally posted by Ernie57
quote:
Originally posted by rockmoose
"Playing around with diagrams"You should get a grasp of constraints.If they show up in the browser (and how) depends on the application programming.rockmoose
I don't know how I did it, but thank you anyway!Ernie
Great!Next puzzle is to understand how!With greater understanding, more control.rockmoose |
|
|
|
|
|
|
Errors generated from a form online