Topics | Search Log Out | Register | Edit Profile
Hide Clipart | Banned/Unbanned User Log | Moderator Login History | Thread Delete/Move Log | Last 30 mins | 1 | 2
Calling SQL experts

Chalanachithram.com DB » New TF Industry Related » Archive through August 23, 2015 » Calling SQL experts « Previous Next »
Author Message
 

Kindal
Side Hero
Username: Kindal

Post Number: 2732
Registered: 09-2007
Posted From: 14.139.128.20

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 11:39 pm:       


Twitter:

expose



I may be wrong to say this, requirement lo leka pothe.. path expose cheyyadam lite teeskovachu.. I know few customers are not bothered with this.
!ntfi
 

Twitter
Legend
Username: Twitter

Post Number: 39289
Registered: 10-2009
Posted From: 98.26.64.91

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 05:34 pm:       


Gotcha:

MVC lo url path will be just name to the class kada. aa class can handle the logic kada.




yeah kaani ivvi pre-generated pdf files kept in a shared location.. nen build chese list lo links untai ..avvi on demand generate chese files aithe nuvvannattu class chooskunedhi..kaani naakante mundhu develop chesi denkesinodu ala punadhulu vesadu ..nen ekkuva dig cheyakunda view and model level lo pani kanichheyyali ..
so model lo aa url list build ayyeppudu emanna masking cheyocchemo ani checking..

otherwise alternative solution is i will just expose some parameters to the link and write a method in the model to give that file..
 

Gotcha
Megastar
Username: Gotcha

Post Number: 21997
Registered: 02-2008
Posted From: 8.19.193.14

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 05:19 pm:       


Twitter:


MVC lo url path will be just name to the class kada. aa class can handle the logic kada.
This Andhra real estate is for sale.
 

Twitter
Legend
Username: Twitter

Post Number: 39287
Registered: 10-2009
Posted From: 98.26.64.91

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 05:18 pm:       


Driverramudu:




ba nuv mvc lone kadha chesedhi..url masking emanna idea undha ..

problem:

iam building a Accordion(knockout js) list which has view and download links , user session authenticated kaani view and dwonload fn's are exposing file path.

i dont wat user to see the filepath, so i am looking for some solution for this, i want to build the same list but urls somehow encrypt or masking cheyyali , download aithe ajax call chesi edhanna cheyochhu kaani view maathram url unchalsindhe ..
any asp.net experts can throw some light on this ..
 

Driverramudu
Hero
Username: Driverramudu

Post Number: 14084
Registered: 02-2009
Posted From: 166.170.14.75

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 05:01 pm:       

Masularex

I don't get any surprise as I see many in my coworkers
They don't know SQL

Oops meeda working Setta RDBMS or SQL tough ante
Eti settam seppu
Bottom line is ppl are more dependent on specific ante rest of tech
Anta tough why do we spent time on it ani feeling

Otherwise one week adi maximum to learn RDBMS ado development
Point of view already we all have enough intelligent to understand and work
In much complex algorithm likes oops etc
Driving is my PASSION.
Ball or Bimmer does not matter.
 

Masularex
Side Hero
Username: Masularex

Post Number: 5586
Registered: 05-2010
Posted From: 175.101.68.85

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 04:13 pm:       


Zingthing:

?? kyon bhayya?


ilanti specific job related technical questions adigetappudu siggu padara ?
 

Zingthing
Comedian
Username: Zingthing

Post Number: 1040
Registered: 01-2011
Posted From: 216.195.1.16

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 03:48 pm:       


Gandhiguevara:

meerantha industry lo yennella nundi vunnaru? inkaa entha mandi vunnaru mee bacth?



?? kyon bhayya?
 

Gandhiguevara
Legend
Username: Gandhiguevara

Post Number: 54613
Registered: 10-2009
Posted From: 98.193.178.109

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 03:37 pm:       

meerantha industry lo yennella nundi vunnaru? inkaa entha mandi vunnaru mee bacth?
 

Wellsfargo
Side Hero
Username: Wellsfargo

Post Number: 4600
Registered: 06-2012
Posted From: 183.83.39.12

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 03:30 pm:       


Eureka:

How to include multiple like conditions in select query
already it has multiple joins and I have to add conditions like
AND CMC_CLCL_CLAIM.CLCL_CUR_STS = '02'
AND CMC_CLCL_CLAIM.NWNW_ID IN ('ALIGN0001','ALNPCP001')
AND CMC_CLCL_CLAIM.PDPD_ID like 'AW%','XJ%' -- need help in this line




Logic pakkana pettu. Ilanti dikku malina query avasaram enti. foreign keys pettu CMC_CLCL_CLAIM.PDPD_ID column ki...
 

Zingthing
Comedian
Username: Zingthing

Post Number: 1032
Registered: 01-2011
Posted From: 216.195.1.16

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 02:27 pm:       

aa filter columns paina indexes unnaayaa? :-)
 

Driverramudu
Hero
Username: Driverramudu

Post Number: 14083
Registered: 02-2009
Posted From: 166.170.14.75

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 02:19 pm:       

Saint

But he can make use of in operator provided
If he uses left function extracting first two characters
Driving is my PASSION.
Ball or Bimmer does not matter.
 

Rusthum
Side Hero
Username: Rusthum

Post Number: 2865
Registered: 04-2015
Posted From: 69.195.35.1

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 02:03 pm:       


Saint:

U cant use in and like in the same one




I am really not sure how you got Moderation. If I were the Mod or Admin I would have definitely banned your ip and deleted your ID without no hesitation. I dont want to extend this matter. I am done when I dont want to argue with people whom I dont like. PERIOD - Catalyst
 

Eureka
Junior Artist
Username: Eureka

Post Number: 216
Registered: 06-2013
Posted From: 208.81.12.35

Rating: N/A
Votes: 0 (Vote!)

Posted on Friday, August 21, 2015 - 01:37 pm:       

Thanks bedars
 

Kuyyo_morro
Hero
Username: Kuyyo_morro

Post Number: 19686
Registered: 02-2011
Posted From: 173.169.22.176

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, August 20, 2015 - 12:26 pm:       


Vja2va:


AND CMC_CLCL_CLAIM.CLCL_CUR_STS = '02'
AND CMC_CLCL_CLAIM.NWNW_ID IN ('ALIGN0001','ALNPCP001')
AND (CMC_CLCL_CLAIM.PDPD_ID like 'AW%' or CMC_CLCL_CLAIM.PDPD_ID like 'XJ%')


idi perfect
 

Sachin
Legend
Username: Sachin

Post Number: 39421
Registered: 04-2008
Posted From: 208.78.147.194

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, August 20, 2015 - 12:13 pm:       

AND CMC_CLCL_CLAIM.CLCL_CUR_STS = '02'
AND CMC_CLCL_CLAIM.NWNW_ID IN ('ALIGN0001','ALNPCP001')
AND regexp_like(CMC_CLCL_CLAIM.PDPD_ID ,'^AW|XJ')

am assuming u want CMC_CLCL_CLAIM.PDPD_ID thats starts with AW or XJ
 

Vja2va
Side Hero
Username: Vja2va

Post Number: 2435
Registered: 11-2014
Posted From: 158.74.35.8

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, August 20, 2015 - 12:09 pm:       


Eureka:




AND CMC_CLCL_CLAIM.CLCL_CUR_STS = '02'
AND CMC_CLCL_CLAIM.NWNW_ID IN ('ALIGN0001','ALNPCP001')
AND (CMC_CLCL_CLAIM.PDPD_ID like 'AW%' or CMC_CLCL_CLAIM.PDPD_ID like 'XJ%')
 

Saint
Legend
Username: Saint

Post Number: 55244
Registered: 01-2011
Posted From: 174.71.32.146

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, August 20, 2015 - 12:07 pm:       

Regexp_like

U cant use in and like in the same one
 

Eureka
Junior Artist
Username: Eureka

Post Number: 215
Registered: 06-2013
Posted From: 208.81.12.35

Rating: N/A
Votes: 0 (Vote!)

Posted on Thursday, August 20, 2015 - 12:02 pm:       

How to include multiple like conditions in select query
already it has multiple joins and I have to add conditions like
AND CMC_CLCL_CLAIM.CLCL_CUR_STS = '02'
AND CMC_CLCL_CLAIM.NWNW_ID IN ('ALIGN0001','ALNPCP001')
AND CMC_CLCL_CLAIM.PDPD_ID like 'AW%','XJ%' -- need help in this line

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x960d698){Movie Clipart}
Show / hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

  A   B   C   D   E   F   G   H   I   J   K   L   M  

N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: