Thursday, May 29, 2008

[itsdifferent] A Tiny Fruit That Tricks the Tongue

A small red berry called miracle fruit temporarily rewires the way the palate perceives sour flavors, rendering lemons as sweet as candy.

read more on nytimes

Regards,
Sudev Gandhi

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Everyday Wellness

on Yahoo! Groups

Find groups that will

help you stay fit.

Yahoo! Groups

Familyographer Zone

Join a group and

share your pictures.

Do-It-Yourselfers

on Yahoo! Groups

How-to ideas,

projects and more.

.

__,_._,___

Wednesday, May 28, 2008

[itsdifferent] Re: Comma separated list of values of single Database table field

I Normally use Regular Expressions, however this depends on where you
want the presentation layer, on Business Module / Database or in the
actual presentation.

thanks

--- In itsdifferent@yahoogroups.com, "sudev_gandhi" <sudev.gandhi@...>
wrote:
>
>
> Of course one can do it... but when you require this kind of information
> programatically you need to iterate through records. In that case he'll
> have to use some piece of program using loop constructs like cursors (in
> case of T-SQL) or if he prefer he can do it by iterating in ADO.Net
> dataset also.
>
>
>
>
> --- In itsdifferent@yahoogroups.com, "Brijesh" <brijesh.pandya@>
> wrote:
> >
> > I would have just copied single column output in a text editor and did
> > a newline V/s Comma replacement.
> >
> >
> > --- In itsdifferent@yahoogroups.com, "sudev_gandhi" sudev.gandhi@
> > wrote:
> > >
> > > Many times you need to create a comma seperated list of values in a
> > > table. Here is a line of T-SQL solution to get comma separated list
> of
> > > values of single field of a database table.
> > > DECLARE @commaSeparatedVal AS VARCHAR(MAX);
> > >
> > > SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +',','') +
> > > CONVERT(VARCHAR,[SKU]) FROM PRODUCT
> > >
> > > PRINT @commaSeparatedVal
> > >
> > > Regards,
> > > Sudev Gandhi
> > > [Recent Articles On My Blog] <http://sudev.blogspot.com/>
> > >
> >
>

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Y! Messenger

Files to share?

Send up to 1GB of

files in an IM.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Special K Group

on Yahoo! Groups

Join the challenge

and lose weight.

.

__,_._,___

[itsdifferent] Re: Comma separated list of values of single Database table field

Of course one can do it... but when you require this kind of information programatically you need to iterate through records. In that case he'll have to use some piece of program using loop constructs like cursors (in case of T-SQL) or if he prefer he can do it by iterating in ADO.Net dataset also.

 


--- In itsdifferent@yahoogroups.com, "Brijesh" <brijesh.pandya@...> wrote:
>
> I would have just copied single column output in a text editor and did
> a newline V/s Comma replacement.
>
>
> --- In itsdifferent@yahoogroups.com, "sudev_gandhi" sudev.gandhi@
> wrote:
> >
> > Many times you need to create a comma seperated list of values in a
> > table. Here is a line of T-SQL solution to get comma separated list of
> > values of single field of a database table.
> > DECLARE @commaSeparatedVal AS VARCHAR(MAX);
> >
> > SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +',','') +
> > CONVERT(VARCHAR,[SKU]) FROM PRODUCT
> >
> > PRINT @commaSeparatedVal
> >
> > Regards,
> > Sudev Gandhi
> > [Recent Articles On My Blog] <http://sudev.blogspot.com/>
> >
>

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Need traffic?

Drive customers

With search ads

on Yahoo!

John McEnroe

on Yahoo! Groups

Join him for the

10 Day Challenge.

Yahoo! Groups

Special K Challenge

Join others who

are losing pounds.

.

__,_._,___

[itsdifferent] Re: Comma separated list of values of single Database table field

I would have just copied single column output in a text editor and did
a newline V/s Comma replacement.

--- In itsdifferent@yahoogroups.com, "sudev_gandhi" <sudev.gandhi@...>
wrote:
>
> Many times you need to create a comma seperated list of values in a
> table. Here is a line of T-SQL solution to get comma separated list of
> values of single field of a database table.
> DECLARE @commaSeparatedVal AS VARCHAR(MAX);
>
> SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +',','') +
> CONVERT(VARCHAR,[SKU]) FROM PRODUCT
>
> PRINT @commaSeparatedVal
>
> Regards,
> Sudev Gandhi
> [Recent Articles On My Blog] <http://sudev.blogspot.com/>
>

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
Y! Messenger

Send pics quick

Share photos while

you IM friends.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Family Photos

Learn how to best

capture your

family moments.

.

__,_._,___

[itsdifferent] Comma separated list of values of single Database table field

Many times you need to create a comma seperated list of values in a table. Here is a line of T-SQL solution to get comma separated list of values of single field of a database table.
 

DECLARE @commaSeparatedVal AS VARCHAR(MAX);

SELECT @commaSeparatedVal = ISNULL(@commaSeparatedVal +',','') + CONVERT(VARCHAR,[SKU]) FROM PRODUCT

PRINT @commaSeparatedVal

Regards,
Sudev Gandhi

Recent Articles On My Blog

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
New business?

Get new customers.

List your web site

in Yahoo! Search.

Y! Messenger

Send pics quick

Share photos while

you IM friends.

Wellness Spot

Embrace Change

Break the Yo-Yo

weight loss cycle.

.

__,_._,___

Tuesday, May 27, 2008

Useful Windows RUN Commands

To Access….
Run Command
Accessibility Controls
access.cpl
Add Hardware Wizard
hdwwiz.cpl
Add/Remove Programs
appwiz.cpl
Administrative Tools
control admintools
Automatic Updates
wuaucpl.cpl
Bluetooth Transfer Wizard
fsquirt
Calculator
calc
Certificate Manager
certmgr.msc
Character Map
charmap
Check Disk Utility
chkdsk
Clipboard Viewer
clipbrd
Command Prompt
cmd
Component Services
dcomcnfg
Computer Management
compmgmt.msc
Date and Time Properties
timedate.cpl
DDE Shares
ddeshare
Device Manager
devmgmt.msc
Direct X Control Panel (If Installed)*
directx.cpl
Direct X Troubleshooter
dxdiag
Disk Cleanup Utility
cleanmgr
Disk Defragment
dfrg.msc
Disk Management
diskmgmt.msc
Disk Partition Manager
diskpart
Display Properties
control desktop
Display Properties
desk.cpl
Display Properties (w/Appearance Tab Preselected)
control color
Dr. Watson System Troubleshooting Utility
drwtsn32
Driver Verifier Utility
verifier
Event Viewer
eventvwr.msc
File Signature Verification Tool
sigverif
Findfast
findfast.cpl
Folders Properties
control folders
Fonts
control fonts
Fonts Folder
fonts
Free Cell Card Game
freecell
Game Controllers
joy.cpl
Group Policy Editor (XP Prof)
gpedit.msc
Hearts Card Game
mshearts
Iexpress Wizard
iexpress
Indexing Service
ciadv.msc
Internet Properties
inetcpl.cpl
IP Configuration (Display Connection Configuration)
ipconfig /all
IP Configuration (Display DNS Cache Contents)
ipconfig /displaydns
IP Configuration (Delete DNS Cache Contents)
ipconfig /flushdns
IP Configuration (Release All Connections)
ipconfig /release
IP Configuration (Renew All Connections)
ipconfig /renew
IP Configuration (Refreshes DHCP & Re-Registers DNS)
ipconfig /registerdns
IP Configuration (Display DHCP Class ID)
ipconfig /showclassid
IP Configuration (Modifies DHCP Class ID)
ipconfig /setclassid
Java Control Panel (If Installed)
jpicpl32.cpl
Java Control Panel (If Installed)
javaws
Keyboard Properties
control keyboard
Local Security Settings
secpol.msc
Local Users and Groups
lusrmgr.msc
Logs You Out Of Windows
logoff
Microsoft Chat
winchat
Minesweeper Game
winmine
Mouse Properties
control mouse
Mouse Properties
main.cpl
Network Connections
control netconnections
Network Connections
ncpa.cpl
Network Setup Wizard
netsetup.cpl
Notepad
notepad
Nview Desktop Manager (If Installed)
nvtuicpl.cpl
Object Packager
packager
ODBC Data Source Administrator
odbccp32.cpl
On Screen Keyboard
osk
Opens AC3 Filter (If Installed)
ac3filter.cpl
Password Properties
password.cpl
Performance Monitor
perfmon.msc
Performance Monitor
perfmon
Phone and Modem Options
telephon.cpl
Power Configuration
powercfg.cpl
Printers and Faxes
control printers
Printers Folder
printers
Private Character Editor
eudcedit
Quicktime (If Installed)
QuickTime.cpl
Regional Settings
intl.cpl
Registry Editor
regedit
Registry Editor
regedit32
Remote Desktop
mstsc
Removable Storage
ntmsmgr.msc
Removable Storage Operator Requests
ntmsoprq.msc
Resultant Set of Policy (XP Prof)
rsop.msc
Scanners and Cameras
sticpl.cpl
Scheduled Tasks
control schedtasks
Security Center
wscui.cpl
Services
services.msc
Shared Folders
fsmgmt.msc
Shuts Down Windows
shutdown
Sounds and Audio
mmsys.cpl
Spider Solitare Card Game
spider
SQL Client Configuration
cliconfg
System Configuration Editor
sysedit
System Configuration Utility
msconfig
System File Checker Utility (Scan Immediately)
sfc /scannow
System File Checker Utility (Scan Once At Next Boot)
sfc /scanonce
System File Checker Utility (Scan On Every Boot)
sfc /scanboot
System File Checker Utility (Return to Default Setting)
sfc /revert
System File Checker Utility (Purge File Cache)
sfc /purgecache
System File Checker Utility (Set Cache Size to size x)
sfc /cachesize=x
System Properties
sysdm.cpl
Task Manager
taskmgr
Telnet Client
telnet
User Account Management
nusrmgr.cpl
Utility Manager
utilman
Windows Firewall
firewall.cpl
Windows Magnifier
magnify
Windows Management Infrastructure
wmimgmt.msc
Windows System Security Tool
syskey
Windows Update Launches
wupdmgr
Windows XP Tour Wizard
tourstart
Wordpad
write



Monday, May 26, 2008

[itsdifferent] Importance of !important in CSS

Do you know What does !important mean in CSS?, an "!important" declaration (the keywords "!" and "important" follow the declaration) this takes high precedence over a normal declaration. And can be framed in this way, this means that the styles are applied in order as they are read by the browser.

CSS it tries to create a balance of power between author and user style sheets. By default, rules in an author's style sheet override those in a user's style sheet. But in CSS1, this is in other way round - Author "!important" rules took precedence over User "!important" rules.


For Example:
User's Style Sheet:
   1: <style> 
   2:   p{font-size: 2em !important;} 
   3:   p{font-style: italic;} 
   4: </style>

Author's Style Sheet:
   1: <style> 
   2:   p{font-size: 3em;} 
   3:   p{font-style: normal;} 
   4: </style> 

If you see in the above instance, the first rule in the User's Style Sheet has "!important" declaration, which will overrides the first rule in the Author's Style Sheet. And if you observe for the second rule in User's Style Sheet it does not contain "!important" so this will be ruled out because here second rule in the Author's Style Sheet has got high preference so the HTML will render by taking size as "p{font-style: normal;}"

If you would like to know more on this, then check with the w3 site:
w3.org and move to the section called "6.4.2 !important rules"
 
Regards,
 
Sudev Gandhi

Sudev Gandhi Blog

ยช Grab this Headline Animator

__._,_.___
Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators
New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Y! Messenger

Files to share?

Send up to 1GB of

files in an IM.

Yahoo! Groups

Women of Curves

Discuss food, fitness

and weight loss.

.

__,_._,___