Click here to Skip to main content
14,830,769 members

Comments by jaket-cp (Top 200 by date)

jaket-cp 17-Jun-19 5:04am View
   
? liquid helium - mri
jaket-cp 10-May-19 4:07am View
   
nice 5ed
jaket-cp 9-May-19 8:35am View
   
nice solution - my 5
very similar to mine - but you beat me to it :)
jaket-cp 1-Apr-19 12:12pm View
   
my 5 :)
jaket-cp 1-Apr-19 12:11pm View
   
just for curiosity
could you not use
pro_price BETWEEN 1000 AND 5000
???
jaket-cp 26-Feb-19 4:53am View
   
nice my 5 :)
jaket-cp 22-Feb-19 8:30am View
   
I believe Maciej Los wants to know if the times (start and end) - can it be for example 9:35AM

Also can the start and end times span over days?
jaket-cp 15-Jan-19 7:08am View
   
done a google search for
python int isdigit
https://stackoverflow.com/questions/33049167/attributeerror-int-object-has-no-attribute-isdigit
From the link
isdigit() works only for strings
jaket-cp 11-Jan-19 5:00am View
   
Agreed +5
Just a small point - if the op wants to save client side they could use the following
https://github.com/eligrey/FileSaver.js/
jaket-cp 11-Jan-19 4:53am View
   
Looking at the foreach loops
If first condition true (location and item type match)
when DataTable A row "Type" != "GRN"
and DataTable B row "Type" != "STK_ADJ"
I think a row of following will be produced:
| Location | Item Type | AmountA | AmountB | Type |
| A | A | | | |
Is this what you expect?

Another question:
If first condition true (location and item type match)
when DataTable A row "Type" == "GRN"
you want a row added?
when DataTable B row "Type" == "STK_ADJ"
you want a row added?

If that is the case, when testing for them - add new row for each true condition
jaket-cp 11-Jan-19 4:22am View
   
did you check the fiddle http://jsfiddle.net/jaket/86f9rc7q/2?
I changed the input type from text to email for input id txtEmail.

Also if you click on the 'Reply' button - then codeproject will inform the user they have a message reply or something.
jaket-cp 11-Jan-19 4:15am View
   
ok - agree with you entirely - new rules, new game :)
happy coding
jaket-cp 11-Jan-19 4:12am View
   
oh okay - new rules :)
jaket-cp 9-Jan-19 11:08am View
   
added to a fiddle and change the type to email
http://jsfiddle.net/jaket/86f9rc7q/2
have a look
jaket-cp 9-Jan-19 10:54am View
   
Having a quick look at the code - I assume validateEmail($(this)); is not being called as the Markup
[input class="form-control" type="text" id="txtEmail" name="txtEmail" required /]
type is text and not email
jaket-cp 9-Jan-19 10:43am View
   
Also its an answer for a question made in 2016 :)
jaket-cp 15-Dec-18 3:03am View
   
glad to help :)
jaket-cp 12-Dec-18 7:34am View
   
nice +5, multiple backgrounds - whoever new?
jaket-cp 19-Sep-18 6:04am View
   
have you looked at LIKE?
Have a read of
https://www.techonthenet.com/oracle/like.php
Practice Exercise #1:

oh right - re-read your question - you need to use a string function of some sort
jaket-cp 19-Sep-18 5:41am View
   
Looking at the error message - put another way - it says attempting to insert null into
JSolutionHR.dbo.tblEmployeeMaster.RevisionNo

Check to see what you are getting for
Select @RevisionNo = RevisionNo+1 from tblEmployeeMaster where SID=@EmpSid

Assuming it is getting to this part of the query
jaket-cp 12-Sep-18 4:57am View
   
ok that's good :)
jaket-cp 12-Sep-18 4:40am View
   
not used vb.net for some time
When assigning variable as string, should it be as follows:
Dim inputpath As String = TextBox1.Text
jaket-cp 12-Sep-18 4:31am View
   
what is the value of inputpath (TextBox1.Text)
and is the value of inputpath a local path to input media file
https://www.nrecosite.com/doc/NReco.VideoConverter/html/M_NReco_VideoConverter_FFMpegConverter_ConvertMedia_3.htm
jaket-cp 10-Jul-18 10:10am View
   
yep I did - I replied to the first comment and not yours
jaket-cp 6-Jul-18 4:54am View
   
oh right - you want the query to get dynamic columns to put in the pivot query.
From my understanding it is not possible.
if you do a google search http://lmgtfy.com/?q=tsql+dynamic+pivot+columns
you will see that is how it is done

I use similar technique to do dynamic pivots.
jaket-cp 6-Jul-18 4:46am View
   
http://lmgtfy.com/?iie=1&q=asp.net+c%23+mvc+pdf+viewer+free
jaket-cp 6-Jul-18 4:10am View
   
print it and you can see the final static query

print @query;
jaket-cp 26-Jun-18 3:21am View
   
glad to help - but I see that Solution 1 is good, he gets my 5+
jaket-cp 22-Jun-18 8:11am View
   
what is pdfWriter?
jaket-cp 22-Jun-18 8:05am View
   
You should be able to do it in SQL - something like this (untested):
select
gr.room_no,
gr.room_status,
gr.housekeeping_status,
case
when gr.roomno is null then ''
else 'R'
end AmIReserved
from room_master rm
left join guestreservation gr
on rm.roomno = gr.roomno
and cast(getdate() as date) = cast(arrivaldate as date)
;
jaket-cp 12-Jun-18 8:50am View
   
sounds like web scraping is what you want
http://lmgtfy.com/?q=web+scraping+c%23
https://www.codeproject.com/Articles/1041115/Webscraping-with-Csharp
jaket-cp 25-May-18 12:30pm View
   
you can use JavaScriptSerializer to serialize a List<Dictionary<String, Object>>
https://msdn.microsoft.com/en-us/library/system.web.script.serialization.javascriptserializer(v=vs.110).aspx
jaket-cp 23-May-18 12:20pm View
   
never tried that search myself - lol
jaket-cp 17-May-18 5:49am View
   
words of advice from solution 1 and 2 are good.
Here is a quick jsfiddle I knocked up so you can see how you could potentially do it in javascript
https://jsfiddle.net/oqe2um1f/
if you go through this one and see whats going on - there is a next installment of the fiddle to do a count of the letters
happy coding :)
jaket-cp 17-May-18 5:21am View
   
Or you could declare @projektId to store the projektId and used that as an insert for each record
jaket-cp 10-Oct-17 8:28am View
   
How does/do cover_id, file and TestCase relate to each other?
jaket-cp 9-Oct-17 4:40am View
   
What else does the emoji click do?
I ask as if it is only related to the TextArea - you could hide the emoji on the server side when TextArea is being disabled.
jaket-cp 5-Oct-17 7:23am View
   
agreed brilliant - 5'ed
jaket-cp 5-Oct-17 6:51am View
   
I assume the customSelect is a jQuery plugin of some sort.
The code to use to setup the initial customSelect, do the same with the cloned one.
jaket-cp 31-Jul-17 11:49am View
   
why go half way with the cte example?
the select union could go into the cte right?
jaket-cp 31-Jul-17 11:42am View
   
BoySetsFire use the "Have a Question or Comment?" button instead of adding a solution.
jaket-cp 24-Feb-17 4:18am View
   
Yep a bit naughty that, but it was similar to solution 10 by ppolymorphe so I thought it would be okay :) - well I think it is/was similar in any case.
I should have mentioned it was ppolymorphe's solution which made me think of the Enum.
Just wanted to get it out there - to see if was a viable way of doing it :)
jaket-cp 23-Feb-17 5:40am View
   
This does not answer you question, but I wondered how a StringFormat functionality I created some time ago could be converted to remove the last calculation component.
Here is a fiddle I just created to test it out:
https://jsfiddle.net/45k9dq80/
Hope it maybe of some help.
jaket-cp 23-Feb-17 4:13am View
   
glad to help
jaket-cp 22-Feb-17 5:22am View
   
I created a quick fiddle:
https://jsfiddle.net/skobzLs7/
maybe it can help you
jaket-cp 20-Feb-17 12:27pm View
   
if copy and pasting does not work for you - you could try command line to merge the files using copy
copy /b *.css xyz.css
or
copy /b abc.css+efg.css+hij.css xyz.css
check out this link: http://stackoverflow.com/questions/2477271/concatenate-text-files-with-windows-command-line-dropping-leading-lines

if that does not work for you - check out this link
http://www.wikihow.com/Merge-Text-(.Txt)-Files-in-Command-Prompt
jaket-cp 5-Dec-16 10:28am View
   
you may want to look at IDENTITY (Property) (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms186775.aspx
jaket-cp 5-Aug-16 10:04am View
   
thanks - i feel like a dunce :)
jaket-cp 20-Jun-16 11:30am View
   
genius +5
but not sure what SET DATEFIRST 1; is for :)
jaket-cp 28-Apr-16 4:14am View
   
Implementing a search type engine is no simple task - especially if you want it to be fast.
Have you considered looking at third party tools?

Here is a link to one: https://www.wrensoft.com/zoom/
Not sure if that will help, as do not know what type of information is to be searched.
jaket-cp 25-Apr-16 4:31am View
   
Query analyzer - that is old school :)
It is a bit more of a mouth full now - Microsoft SQL Server Management Studio (or SSMS for short)
jaket-cp 21-Apr-16 4:30am View
   
This is not a solution, you should remove it.
Use the reply link type button to reply to comments.
Or improve the question with this information.
jaket-cp 14-Apr-16 7:06am View
   
Glad to help.
Just remove your solution 1, as it not an answer.
Also have a read of Solution 2 - it explains what I also believe is happening nicely.
jaket-cp 14-Apr-16 4:46am View
   
nice
jaket-cp 14-Apr-16 4:45am View
   
This is not a solution, you should remove it.
If you want to want a comment to a cp memeber, use the reply button and put the comment there.

Did you read the link I put in a comment above?
I do not believe tab indexing is your issue.
jaket-cp 14-Apr-16 4:18am View
   
have a read of this:
http://stackoverflow.com/questions/4209903/asp-net-page-enter-key-causing-post-back
it should give you a few options to do what you want.

http://lmgtfy.com/?q=asp.net+form+disable+enter+submit
jaket-cp 13-Apr-16 9:58am View
   
Glad to help :)
jaket-cp 13-Apr-16 4:34am View
   
I found a link that may help you out some more:
http://codetunnel.io/how-to-debug-your-aspnet-projects-running-under-iis/
jaket-cp 12-Apr-16 7:56am View
   
In visual studio 2013 you could try changing the properties of the web project.
Solution Explorer > right click web project > Properties
Web > Servers > Select Local IIS
In any case fiddle with the server settings
jaket-cp 7-Apr-16 6:27am View
   
Sinisa, by any chance to you have a reference link where it states the common use of lower case for css class names.
If you know of a pros-cons link that would be good.
As I on the whole use PascalCase for css class naming.
thanks
jaket-cp 7-Apr-16 6:25am View
   
glad to help
also have a look at
https://jsfiddle.net/5oty8wvb/1/
https://jsfiddle.net/5oty8wvb/2/
to see how the code can be mixed about.
Play around with them to made improvements for code re-use.
jaket-cp 7-Apr-16 5:20am View
   
Also populating backgrounds array - extra [comma] needs to be removed.
https://jsfiddle.net/5oty8wvb/
jaket-cp 4-Apr-16 4:27am View
   
Can you supply the javascript code and possibly the generated markup, so we can let you know where you are going wrong.
If you are using rowspan, you will need to remove the td/cells of the the ones added by the rowspan - hope that makes sense.
jaket-cp 31-Mar-16 7:40am View
   
have a read of:
https://msdn.microsoft.com/en-us/library/ms188385.aspx
ORDER BY Clause (Transact-SQL)
Specifying a conditional order

It should help you out, you should be able swap out the column with the variable @SortOrder.
You maybe required to have the case statement multiple times for each additional column sort.
jaket-cp 31-Mar-16 7:19am View
   
No problem glad to help.
Hope you have learnt some more today :)
jaket-cp 31-Mar-16 7:18am View
   
Good to hear.
We got there eventually :)
jaket-cp 31-Mar-16 7:12am View
   
not the

AS
BEGIN

But the

begin
IF @abc='insert' and ...


The @data table insert and select statement needs changing.
The where clause should be where UnderGroup='Sales A/C'
you have added an extra @, where it is checking if the variable
@UnderGroup is the sales value.
jaket-cp 31-Mar-16 7:05am View
   
Yeah you are probably right, but after reading it, I started putting them everywhere.
And also because I started using cte more.
For some reason don't like the look of
;with
it just don't look right :)
jaket-cp 31-Mar-16 6:55am View
   
As i mentioned there is a begin before the if - what is it doing there?

A way of finding out what the values of @abc and @Group_Name are is do a print of them just before the if statement and when you run it should show up in the messages tab (that is if you are using sql server management studio)
jaket-cp 31-Mar-16 6:48am View
   
But what is the value of @abc and @Group_Name when it gets to the if statement?
For example: when @abc = 'UPDATE' then it will not meet the criteria of the if statement and the insert will not be performed.
jaket-cp 31-Mar-16 6:42am View
   
Here it is:

"Not ending Transact-SQL statements with a semicolon" has been put in the list of
Features Not Supported in a Future Version of SQL Server
https://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx

I have been recommending to possibly get in the habit of using the semicolon statement terminator for all statements.

Maybe I shouldn't be doing that anymore?
jaket-cp 31-Mar-16 6:39am View
   
Thanks for that :)
I try to put them in as good practice even though they are not required.
Maybe it is not good practice then :(

I read somewhere that the semicolon is required to terminate all statements in possible future releases of MSSQL server.

Let me see if I can find the link.
jaket-cp 31-Mar-16 6:33am View
   
okay - how do you know it is not working?

what are the values of @abc and @Group_Name
and the begin for the if is in the wrong place.
jaket-cp 31-Mar-16 6:17am View
   
Just wandering why you would say "the terminating semicolon is redundant"?
jaket-cp 31-Mar-16 5:43am View
   
I do not believe the "or" in the if condition is that issue.
I have posted a solution which maybe the cause of the problem.
jaket-cp 31-Mar-16 5:35am View
   
are they the same value?
jaket-cp 31-Mar-16 5:35am View
   
okay - that will not work
jaket-cp 31-Mar-16 5:27am View
   
how many?
jaket-cp 31-Mar-16 5:03am View
   
execute the following:
select Group_Name from tbl_AccountGroup where UnderGroup='Sales A/C'
what is being returned?
jaket-cp 31-Mar-16 4:44am View
   
Depends on what you mean by last 10 records.
If you mean the last 10 records that have been inserted into the table, then you will probably have to look in the transaction logs.

But if you want to delete the last 10 records ordered by FirstName, MiddleName or LastName, then that is more straight forward.
jaket-cp 31-Mar-16 4:37am View
   
if that is what you are doing, then you could also do it like this:
@Group_Name IN ('Capital Account','Current Liabilities','Current Assets','Fixed Assets','Profit & Loss','Revenue Account','Suspense Account','Loan')
OR
@Group_Name IN (
SELECT 'Capital Account'
UNION ALL
SELECT 'Current Liabilities'
UNION ALL
SELECT 'Current Assets'
UNION ALL
SELECT 'Fixed Assets'
UNION ALL
SELECT 'Profit & Loss'
UNION ALL
SELECT 'Revenue Account'
UNION ALL
SELECT 'Suspense Account'
UNION ALL
SELECT 'Loan'
)


But I suppose it can be maintained more easily when placed stored in the @data table.

Hope that helps you out.

But on second thought, it would be better if you create a permanent Group lookup type table. As suggested in solution 1 oops meant solution 2.

For example if a new Group_Name was required, then all you need to do is insert it into the Group lookup table rather than modifying the sql code to add the extra group into the list.
jaket-cp 31-Mar-16 4:23am View
   
As in your sql code.
Remove delcare, insert and select from @data table.
Add in grp for the select statement, like below:

SELECT 'Capital Account' grp
UNION ALL
SELECT 'Current Liabilities'
UNION ALL
SELECT 'Current Assets'
UNION ALL
SELECT 'Fixed Assets'
UNION ALL
SELECT 'Profit & Loss'
UNION ALL
SELECT 'Revenue Account'
UNION ALL
SELECT 'Suspense Account'
UNION ALL
SELECT 'Loan';
jaket-cp 31-Mar-16 4:12am View
   
If that is all you need to do, then you do not need to insert into a temp variable table. Unless you are using the @data TABLE in multiple places.

Just do the select with union all and give the first column an alias of grp.
SELECT 'Capital Account' grp
UNION ALL
...
jaket-cp 30-Mar-16 4:44am View
   
Can you give an example on how you would like to use the list.
jaket-cp 11-Mar-16 7:17am View
   
On a side note: possibly get in the habit of using the semicolon statement terminator for all statements.

"Not ending Transact-SQL statements with a semicolon" has been put in the list of
Features Not Supported in a Future Version of SQL Server
https://msdn.microsoft.com/en-us/library/ms143729(v=sql.120).aspx

Not saying it is going to happen any time soon though.
jaket-cp 11-Mar-16 4:59am View
   
Did you find the link from d@nish?
jaket-cp 11-Mar-16 4:43am View
   
i suggest you remove it unless any others mark you down - i will compensate it a little by giving it a few extra stars
jaket-cp 11-Mar-16 4:41am View
   
that is harsh you getting mark down for this solution
jaket-cp 10-Mar-16 5:03am View
   
Thanks for that, but I understand what is happening but the op does not.
I would also give links to DateDiff and GetDate.
And probably explain in pseudocode code what is happening, that would be a improved solution and I would give you a 5star for that :)
jaket-cp 10-Mar-16 4:25am View
   
It would be good if you could do an In Long version of your solution
jaket-cp 10-Mar-16 4:03am View
   
these are all 3rd party solution - the op asked for non 3rd party tools.....
jaket-cp 7-Mar-16 11:25am View
   
It sticks in my head as the first time I saw it, I was using 2008 to try it out, with no luck :)
jaket-cp 7-Mar-16 11:20am View
   
Just a small point, the CONCAT function becomes available in SQL Server 2012+
jaket-cp 25-Feb-16 10:18am View
   
Good that is good :)
jaket-cp 25-Feb-16 10:13am View
   
Looks correct to me.
It could be a browser cache issue.
You may have to perform a hard-refresh
ctrl+F5 or ctrl+R
http://refreshyourcache.com/en/cache/
jaket-cp 25-Feb-16 9:32am View
   
Did you change the function name to submitChangej?
jaket-cp 19-Feb-16 4:47am View
   
This is not a solution, you should remove it.
I have also put up another solution using PATINDEX, have a read.
jaket-cp 5-Feb-16 5:22am View
   
I was just wondering would there be a major benefit in having an index on Match_Flag if only two possible values of 'Y' and 'N' exist.
I would have suggested putting a clustered index on columns Store_Range_Grp_Id, Range_Event_Id.

As I said, just wondering that is all...
jaket-cp 5-Feb-16 4:17am View
   
How did you try to add the cascade?

You should be able to remove the Foreign Key constraint and then add it back with the on delete cascade or on update cascade

Have a read of
https://msdn.microsoft.com/en-us/library/ms175493.aspx

which in turn you should read
https://msdn.microsoft.com/en-us/library/ms189579.aspx
and then
https://msdn.microsoft.com/en-us/library/ms189049.aspx
jaket-cp 4-Feb-16 10:32am View
   
maybe try putting the column name in square brackets like so [E-Run Time], it may help.

Have a read of:
https://technet.microsoft.com/en-us/library/ms176027(v=sql.105).aspx
jaket-cp 4-Feb-16 8:05am View
   
have a read of these:
sp_rename (Transact-SQL) - https://msdn.microsoft.com/en-GB/library/ms188351(v=sql.105).aspx
How to: Rename Tables (Visual Database Tools) - https://msdn.microsoft.com/en-us/library/aa337520(v=sql.105).aspx
they should help you out

Top two links:
http://lmgtfy.com/?q=mssql+rename+table
jaket-cp 1-Feb-16 4:28am View
   
maybe have a read of
http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxtreegrid/jquery-treegrid-getting-started.htm?search=
it may help you out.
jaket-cp 1-Feb-16 4:23am View
   
check out this fiddle: https://jsfiddle.net/5nq1kzxf/
it appears to work fine
add in the css styling and probably remove
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
jaket-cp 29-Jan-16 6:55am View
   
why do you consider this to be a proper question?
if you have to link off to another site to get the full details of the question
jaket-cp 21-Jan-16 5:35am View
   
You may be interested in or maybe not - but have a read of:
Restore a SQL Server Database to a Point in Time (Full Recovery Model)
https://msdn.microsoft.com/en-us/library/ms179451.aspx
jaket-cp 19-Jan-16 5:23am View
   
It should be possible to do it with an update on a recursive cte.
Or an update on lead/lag - not sure on this one.
But a simulated lead/lag on an join update should work.

In all the above possibilities the ordering of the records need to be defined.
Can you define the ordering of the records.

Also in your example, shouldn't
Investments 240 ahnc Investments
Investments 241 hnnc Investments
be
Investments 240 ahnc
Investments 241 hnnc Investments

As if comparing previous with current,
Investments (240) would be compared with Nokia (610) - no match so Parent would be empty.

Please clarify these points.
Thanks
jaket-cp 19-Jan-16 5:02am View
   
thanks :)
jaket-cp 18-Jan-16 8:39am View
   
okay if that is the case.
Add an additional column, something like this:
year(dateadd(M,-6,ac1.RequestedOn)) FiscalYear
jaket-cp 18-Jan-16 8:34am View
   
What is the fiscal year?
Can it be derived from AdvancePayment.RequestedOn?
jaket-cp 18-Jan-16 8:25am View
   
you are welcome, glad to be of help.
jaket-cp 18-Jan-16 8:00am View
   
thanks, and also thanks for testing :)
jaket-cp 18-Jan-16 7:10am View
   
Thanks for the reasoning.
Similar to the having, adding additional conditions to the where clause can do the same.

My brain is just wired up a bit differently :)
jaket-cp 18-Jan-16 5:16am View
   
Using the "not in" may not be an optimal way of figuring it out.
Have you considered using a left outer join as in solution 1?
jaket-cp 18-Jan-16 5:14am View
   
Why do you use group by?
I would say the following would be easier to understand what is going on:
SELECT distinct WorkNum FROM @TBL where ratecodes = 'toys'
Just wondering that is all...

similar as in solution 2
jaket-cp 4-Dec-15 4:41am View
   
maybe try:
onclick="OpenPage();return false;"
see if that works
jaket-cp 3-Dec-15 7:23am View
   
I assume it has something to do with the css selector:
input:not(:checked) ~ textarea

Have a read of these, they may help you out:
https://developer.mozilla.org/en-US/docs/Web/Guide/CSS/Getting_started/Selectors
https://css-tricks.com/almanac/selectors/c/checked/
jaket-cp 3-Dec-15 5:31am View
   
you can fiddle with the @Today.
SET @Today = DATEADD(month, -12, GETDATE())
jaket-cp 3-Dec-15 5:22am View
   
have a read of
http://www.w3schools.com/jsref/dom_obj_event.asp
https://developer.mozilla.org/en-US/docs/Web/Events

for a possible list of events possible
jaket-cp 3-Dec-15 5:18am View
   
That jsfiddle was to show that label and checkbox can be hidden in the same way as your code does with the submit button.

What you need to do is add an event or something to the input test and trigger the submitChange function.

Here is an update jsfiddle:
http://jsfiddle.net/zg2kbe01/1/
It should get you the idea of how it can be done
An onblur has been added to the input textbox.
When a blur event occurs on the input textbox then the submitChange is called.
This in turn validates the input text box values and will show or hide the Container accordingly.

Hope that gets you on your way.

jaket-cp 2-Dec-15 7:48am View
   
I have created a simple jsfiddle so you can see that show and hide works for checkbox and label.
http://jsfiddle.net/zg2kbe01/
Hope that helps you out
jaket-cp 2-Dec-15 6:45am View
   
you can use style.display on those elements you want to display, block and none - as has been implemented with inputSubmit
jaket-cp 2-Dec-15 6:11am View
   
If I get what you are asking.
You could get submitChange to be called everytime one of the input textbox or checkbox gets changed/modified.
jaket-cp 2-Dec-15 6:02am View
   
also mark it as solved to remove from pool of unanswered questions.
jaket-cp 2-Dec-15 6:00am View
   
glad to help
jaket-cp 2-Dec-15 6:00am View
   
okay that is good, you only require one or the other, not both.
jaket-cp 2-Dec-15 5:50am View
   
okay on that fix.
Which one of the 3 did you try to get the submitChange() to get executed after page load?
jaket-cp 2-Dec-15 5:46am View
   
Just had another look a your javascript
inputlastName is missing value
jaket-cp 2-Dec-15 5:40am View
   
which one did you try?
jaket-cp 27-Nov-15 5:52am View
   
agreed +5
jaket-cp 27-Nov-15 5:38am View
   
More info is require.
I am not sure how office 365 and javascript will be applied.

Also use the 'Improve question' link to update your question.
jaket-cp 27-Nov-15 4:37am View
   
Where is the inbox mail?
You need to supply more information, if you are going to get any help.
jaket-cp 24-Nov-15 4:05am View
   
Have a read of DELETE (Transact-SQL):
https://msdn.microsoft.com/en-us/library/ms189835.aspx
Using joins and subqueries to data in one table to delete rows in another table

Should help you out on how to use joins with delete
jaket-cp 24-Nov-15 4:00am View
   
As F-ES Sitecore has suggested, supply your stored proc so we may be able to help more.

But if you have not check it out already, maybe tsql aggregate functions with over may help.
Have a read of:
https://msdn.microsoft.com/en-GB/library/ms173454.aspx
https://msdn.microsoft.com/en-GB/library/ms189461.aspx
jaket-cp 19-Nov-15 4:27am View
   
If the min(dos) ordering is not correct with servicecode.
You need to figure out what ordering is required and put it in the row_number() over(...) somehow.
I will update the solution to give you an idea.

jaket-cp 19-Nov-15 4:23am View
   
How about situation when * does not exist for the name?
This is the one which I can see not easily definable.

Also the characters before and/or after name are not consistent (include . and " from your sample data).
jaket-cp 18-Nov-15 11:49am View
   
The solutions has been update with a couple of sql(s) which should work.
jaket-cp 18-Nov-15 6:03am View
   
It can be performed in TSQL (using loops and the like) but, I would not say it can be done in one sql statement.

From looking at the summary records, it will be not be straight forward.

Inspecting the first record, I assume they are split like so:
asdffgggggg Anand *
edkkofffmfmmfmfm Bala
sdkdodkekeke Chandra
dkkdkd "vinoth"*

As I can see, there are no easily definable rules to split the mini-records that do not have the * after the name.

If the real data is not like the sample data supplied and it has a split rule that can be used to get the summary separated data. Then it may be possible to get the result within one sql query.

Same question:
Can summary be split with defined rules?
jaket-cp 18-Nov-15 4:02am View
   
okay - sorry about that, thinking of asp.net
jaket-cp 17-Nov-15 11:24am View
   
You could try a client side way of doing it.
Check out this link
http://highcharttable.org/
Have not used it myself, but seems like a viable solution.
jaket-cp 17-Nov-15 10:51am View
   
From what I can see from your sample data, your main issue is initially to separate the summary column into 4 bits of information.
If there is a consistent way to define how to separate the data, then it should be quite straight forward to proceed to the next step.
But it does not appear as though these bits of information can be separated with any definable rules. Unless you take into consideration of the name, but then that will get very messy.

So the question is:
Can summary be split with defined rules?
jaket-cp 16-Nov-15 4:57am View
   
I am not sure who gave a bad rating, the reason is, is you should not put comment as solution.
I advise you to remove this solution and put it in a comment to solution 1 using the "Have a Question or Comment?" button.

But to answer your comment, it will probably be best to use google.
I performed a search of "simple javascript quiz tutorial" and one of the top links is:
http://code.tutsplus.com/tutorials/build-a-spiffy-quiz-engine--net-20185
Hope that helps you out.
jaket-cp 13-Nov-15 10:41am View
   
Why do you what it to be done in javascript?

css should do the trick and would be the correct way of doing it.
Check out:
https://developer.mozilla.org/en-US/docs/Web/CSS/background-image
jaket-cp 13-Nov-15 5:59am View
   
You should reply to the comment so the comment originator (being myself this time) will get a notification.

As I mentioned please supply the generated markup for the img tag.
Use the "Improve question" link/button to update your question.
Also supply the javascript code, the c# code should not be required, if the images are being uploaded as you have stated.
jaket-cp 12-Nov-15 12:07pm View
   
Can you supply the generated markup for the img tag.
Also where are the images stored on the site?

I assume it has something to do with it img src not pointing to the correct path.

Have a read of this, it may help:
https://css-tricks.com/quick-reminder-about-file-paths/
jaket-cp 10-Nov-15 4:38am View
   
The HTML and jQuery appear to be okay - have created a fiddle and it is checking and unchecking all as expected
http://jsfiddle.net/eyLey1v7/ - let me know if I am missing something...

Just a small point on the jQuery, rather than looping through #dtsResult, loop #dtsResultBody instead. Reason being #CheckAllRes will not get checked or unchecked again.
jaket-cp 4-Nov-15 9:07am View
   
As I said I am not the OP.
Was just interested to know the solution to the question of the OP, that is all.
Thanks :)
jaket-cp 4-Nov-15 8:59am View
   
Thanks for the reply - this is not my question.
I was just interested in what the solution could be, but reading the document you pointed to did not answer it for me.
jaket-cp 4-Nov-15 8:54am View
   
From the sub-queries the script is checking for and UserId=7
Also deviceid in (25,30) and deviceid in (26,31) have been specified.
Do these relate to a "punch-in"/"punch-out"?
In the sample data, there is a DeviceId of 29, which is not in the query.
I assume in the output data, you would like to have the UserId.

Please update your question to make it more clear on your requirements, so we may be able to help.
jaket-cp 4-Nov-15 8:31am View
   
Can you specify where in the documentation you are referring, to answer this question.
Thanks
jaket-cp 2-Nov-15 5:17am View
   
It may be a good idea to save the date of birth instead of a fixed age.
The age of the user can be derived from the dob to a given date.
jaket-cp 30-Oct-15 13:25pm View
   
have a read of this:
http://stackoverflow.com/questions/10877407/t-sql-how-to-create-tables-dynamically-in-stored-procedures
it may help
jaket-cp 30-Oct-15 5:08am View
   
A simple select search should suffice.
https://msdn.microsoft.com/en-us/library/ms189499.aspx

But it depends on the search criteria.
Can you specify how the 4 records are derived from the data in #tmpList.
jaket-cp 28-Oct-15 5:29am View
   
I am just interested to know, is this homework or the like?
As these are rudimentary mistakes.
In any case solutions 1 and 2 should answer your question.
jaket-cp 23-Oct-15 9:58am View
   
thanks :)
jaket-cp 23-Oct-15 4:04am View
   
If you are asking about getting the third highest...
Solution 1 has an example.
You could do something like this
select top 1 salary from (select top 3 salary from employee order by salary desc) order by salary.
Not tested, but you should get logic behind it.
have a look at
http://blog.sqlauthority.com/2007/04/27/sql-server-query-to-retrieve-the-nth-maximum-value/

I am quite sure there are other ways of doing it too.
Do a google search of
"tsql select nth record"
http://lmgtfy.com/?q=tsql+select+nth+record
should get you more examples.

Hope that helps out.
jaket-cp 22-Oct-15 12:02pm View
   
not sure, never done that before :)
maybe hover over the solution and it may show up extra links/buttons etc
jaket-cp 22-Oct-15 11:57am View
   
you have everything you need to figure it out.
okay - try this
alert(jQuery.parseJSON(data).position);
jaket-cp 22-Oct-15 11:55am View
   
this is a different question.
But what are you trying to alert?
jaket-cp 22-Oct-15 11:36am View
   
please also mark as solved
jaket-cp 22-Oct-15 11:34am View
   
okay that is good - learn to debug and happy coding :)
jaket-cp 22-Oct-15 11:24am View
   
okay
so alert(data) gets you that, it is probably a string

so try
dataToTable($('#routes'), jQuery.parseJSON(data), 'route');
jaket-cp 22-Oct-15 11:02am View
   
As you can see from the fiddle the dataToTable is working as expected when the data is sent in correctly.
I assume the ajax call is returning something different from what is expected.
It may be getting it back as an xml object or even a string.
Or it could be sending back a json object wrapped in a d.
Hard to tell as I cannot debut the code.
You will need to debug and figure out what the you are getting in the response data.

But try saying that, try
dataToTable($('#routes'), data.d, 'route');
see if that works
jaket-cp 22-Oct-15 10:53am View
   
oh well, it is time to debug.
Try a console.log(data) and see what you get.
jaket-cp 22-Oct-15 6:12am View
   
simulate keydown event javascript
google is your friend:
http://lmgtfy.com/?q=simulate+keydown+event+javascript
http://stackoverflow.com/questions/596481/simulate-javascript-key-events
jaket-cp 20-Oct-15 7:04am View
   
yes - you may be right :)
but your
(year - row_number() over (partition by name order by year)) as grp
was the main part of the solution
just added some extra bits to it, that is all
happy coding
jaket-cp 20-Oct-15 7:02am View
   
thanks
jaket-cp 20-Oct-15 7:01am View
   
:) you are the best...
jaket-cp 20-Oct-15 4:12am View
   
nice - but does not cater for OP continuous 6 years scenario.
When (16, 'Arun', 2005), (17, 'Arun', 2006) is added to the test data, it only returns the first 3 years.
no disrespect :)
jaket-cp 20-Oct-15 3:47am View
   
This question is more than 2 years old, not a good idea to answer old questions.
Also this question has an accepted solution.
On top of that, it does not appear as though your solution will get what the op asked for.
jaket-cp 16-Oct-15 12:32pm View
   
cool, thanks
jaket-cp 16-Oct-15 12:24pm View
   
+5 for the c# and vb.net - neat :)
is that in-built in the wysiwyg editor?
jaket-cp 16-Oct-15 12:19pm View
   
Am I missing something, what is a tap in this context?
jaket-cp 16-Oct-15 12:15pm View
   
more than 2 years old :)
jaket-cp 16-Oct-15 5:36am View
   
this question is more than 2 years old
Also what is the solution you are giving, how does it relate to the question?
jaket-cp 16-Oct-15 4:11am View
   
Update you question with this bit of information - use the "Improve question" Link.
Can you also give more information on why the following should not be returned
aId Bid B.Name
101 201 A
And clarify what you mean by:
b'Coz it have 180 in another row

Include more sample data if this helps with the question
jaket-cp 15-Oct-15 8:09am View
   
have a read of following link
https://msdn.microsoft.com/en-us/library/ms345415(v=sql.110).aspx
jaket-cp 7-Oct-15 5:14am View
   
You could try a dotnet decompiler of some sort.
With a little googling - check out this link it may help:
http://stackoverflow.com/questions/2646707/something-better-than-net-reflector
jaket-cp 7-Oct-15 4:17am View
   
Interesting - at first, I would have said it was not possible in css.
But with a bit of googling I found it can possibly done in css3.
Check out these links:
http://stackoverflow.com/questions/16912023/css3-transition-click-event
http://stackoverflow.com/questions/11166580/css3-transitions-is-there-an-on-click-option-without-using-jquery
http://jsfiddle.net/nMNJE/
and another one
http://vanseodesign.com/css/click-events/
jaket-cp 6-Oct-15 6:49am View
   
Now this one is a 5 year old question and it has a marked solution as well.
jaket-cp 6-Oct-15 6:46am View
   
You are answering a 4 year old question.
That is nice and all, but you may get down voted, even though you have given a good solution.
It maybe a good idea to delete you answer.
jaket-cp 23-Sep-15 4:13am View
   
nice :)
jaket-cp 23-Sep-15 4:08am View
   
What have you tried so far?
If you have not tried anything yet, then please have a read of
http://api.jquery.com/jquery.ajax/

Any issues with that implementation, then update your question and I am sure you will get help.
jaket-cp 23-Sep-15 4:05am View
   
Having a quick look, please fix your html first, it is not well formed.
For a start div tag is not allowed to be a direct child of tr tag.
The opening and closing of div tags are also misplaced.
In the table tag, when implementing css use the style attribute.
jaket-cp 21-Sep-15 4:08am View
   
Not sure, it is hard to say.
Here are a couple of suggestions you could try.
Firstly, figure out if the bind javascript is being executed at all, try debug or the alert/console.log method (put just before the binding).
If it is not being executed, then as you have know, there is an issue with the Master/Content page (probably some other javascript being used in the Master page, or possibly a lack of javascript library).
In any case you need to figure out what the issue is.
What you could do is create a content page with no code-behind and minimal textbox and search textbox to use the Master page (or a copy of the Master page).
If it works then, the problem exists in the original content page, but if it does not, then assume it is in the Master page.
In either case, the next step would be to add/remove components from the offending page (be it content or master) and test on each iteration change to see if it works in the web browser.
Ensure you do a hard-refresh in the web browser, so you hopefully know what is being tested is what you have changed.
http://refreshyourcache.com/en/cache/
http://wiki.scratch.mit.edu/wiki/Hard_Refresh
I believe in most windows web browsers, Ctrl+R will work for a hard-refresh.
Hope that helps out :)
jaket-cp 17-Sep-15 3:54am View
   
That looks okay to me.
It may not be a javascript issue, it could be an issue with the aspx markup or something.
Try and debug as "F-ES Sitecore" has suggested - he knows what he is talking about.
Or you could try using alert or console.log for a quick test to check if the javascript code is doing what you expect.
Here is a quick knocked up fiddle for a simple test http://jsfiddle.net/7kfzwcns/
jaket-cp 14-Sep-15 11:24am View
   
Okay if that is the case, I believe the input data may be incorrect.
I have written a CTE for the child-parent relationship but there are quite a few duplicates and the recursion does not stop, so I had to put a limit in.

You should use the 'Reply', so the user who wrote the comment will get a notification.
jaket-cp 14-Sep-15 11:08am View
   
Just to confirm is the parent, child relationship between DetailComponent and ParentId?
Also can you check you data - is the
union all SELECT 'R222-54','52342-00',6
correct?
jaket-cp 11-Sep-15 7:50am View
   
Just to clarify, are you using "SQL-server-2008R2" and not "SQL Server 2012".
The only reason I ask is that the identity re-seed (jump issue) is a built in feature to "SQL Server 2012".
If you are on "SQL Server 2012", then check out this link:
http://www.codeproject.com/Tips/668042/SQL-Server-Auto-Identity-Column-Value-Jump-Is
jaket-cp 11-Sep-15 4:14am View
   
:)
jaket-cp 11-Sep-15 4:14am View
   
thanks :)
jaket-cp 11-Sep-15 4:10am View
   
:) thanks
jaket-cp 11-Sep-15 3:21am View
   
okay I will try :)
have another read, I have updated solution with comments.
hopefully it should be more clearer :)
jaket-cp 10-Sep-15 11:18am View
   
:)
jaket-cp 10-Sep-15 11:06am View
   
does it matter what order the positive and negative are in?
jaket-cp 25-Aug-15 9:10am View
   
Reading the other comments, have you considered using the SQL Server Profile to see if the statements are being executed on the db server in question.
This link may help: https://msdn.microsoft.com/en-us/library/ms181091(v=sql.110).aspx
jaket-cp 25-Aug-15 8:58am View
   
If I get what you are asking, I have created a fiddle which may help http://jsfiddle.net/d7qzu7fn/3/
Consider the MainImage (red background) as being the skeleton and the numbered images as being the blouse.
Not sure how that would work with transparency though.
jaket-cp 25-Aug-15 8:00am View
   
You should update your question.
But from your comment, you could get the handler to test for Login.aspx and if it is, skip what the handler is doing.
jaket-cp 25-Aug-15 5:19am View
   
this should be a comment not a solution
jaket-cp 24-Jun-15 8:20am View
   
remove the comma after @brandname varchar (100)
see if that works.
jaket-cp 19-Jun-15 6:52am View
   
check out: https://msdn.microsoft.com/en-us/library/bb385097.aspx