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 |
|
jewel
Starting Member
18 Posts |
 Posted - 2004-10-06 : 19:16:52
|
| ok I am setting up audit queries - I have three queries and will post each separately - (1)how can I do the following:I need to verify sentence caseeg emailid - should show John.Smith@aaaa.co.nz - and not john.smith@aaaa.co.nzhow do I set this upmy fields will be:SELECT clientcode // firstname // lastname // emailidFROM clientWHERE client.emailid ?????????thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-07 : 04:19:27
|
| check this site, udf for proper case...http://vyaskn.tripod.com/code.htm#inserts |
 |
|
|
jewel
Starting Member
18 Posts |
Posted - 2004-11-03 : 21:52:49
|
| thanks Jenbut that seems quite advanced for me: from within Visual Studio query panel is where I would normally set or add my query. I can sort of understand what it means but have no idea where to add or put anything in.from the example I have given can you or someone else show me what steps I need to do.thank you |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-03 : 22:34:00
|
| 1. create the function in your database (copy and paste from site) and 2. select spName(emailid)... from client where...i'm not familiar with the query panel, but you can execute the query above through recordset.open query returning the records you want.--------------------keeping it simple... |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-04 : 04:53:02
|
what's the point of doing that for emails?? email is case insensitive anyway...Go with the flow & have fun! Else fight the flow  |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-04 : 04:58:01
|
| i think she's doing it to make the data "pretty" --------------------keeping it simple... |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-04 : 05:03:42
|
oh come on.....  Go with the flow & have fun! Else fight the flow |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-04 : 05:08:08
|
quote:
eg emailid - should show John.Smith@aaaa.co.nz - and not john.smith@aaaa.co.nz
i only hear this type of 'requirement' from our reports group, wherein they specify, they need to show data in a different manner coz it makes the clients happy  serious advice though, this type of requirement should be handled before it is saved in the database or in the presentation layer.--------------------keeping it simple... |
|
|
|
jewel
Starting Member
18 Posts |
Posted - 2004-11-04 : 18:24:53
|
| hi allyes you are right - it is about conformity. Unfortunately the rules for this were not set on the main Oracle database when it was put in, and now would be too much to do. Therefore I am reading the database and setting up audit reports for our service centre to follow up on. That is I run the query in Visual studio and using msdn publish to web for them to follow up.I still need a lot more understanding of Visual etc so am really flying by the seat of my pants in designing these and hopefully will eliminate a lot of problems in the future.I will certainly follow up on your advice here Jen and see if it is something I can do.cheersDianne |
|
|
|
|
|
|
Visual Studio - verify sentence case