Comments by planetz (Top 127 by date)

yes. This query is the old one with old table. Old table is same as table1. But instead of column 'status'(varchar2) it was column 'score'(number).

Hi GobblesGobbles, this is the recording of the manual procedure. I need to get distinct count of data for a particular item. My mistake, I will add an example of my requirement.

this query has to be in a procedure. right? else where can I declare 'a_defined_variable'?

Yes GKP1992, that is correct. I am using oracle 10g.

the output can be achieved by query...but it will be writing same selected lines from 4 different queries. But if thie procedure I asked is even more complicated and time taking, then may be query is a better option.

yes, there is a column that is same for all datasets, but that is not something like a primary key. Just like a student list say, where student name is the common field, and their individual subject marks are 4 datasets and then there is a summary that contains individual subject marks and also total marks.

Great!! List worked!! Thank you!!

'having' clause surely is a condition but it wont check for everyday when they are placed one beside other. For example, if for each day count >1 then output should only have

ename | 01-10-17 | 02-10-17
emp3 | 2 | 2

But with your query it comes as:

ename | 01-10-17 | 02-10-17
emp3 | 2 | 2
emp1 | 3 | null

I have to show individual dates as individual column names and their respective count under them.

This is exactly what I want. It worked and query is understandable. Thank you..!!

But date is an important filter. I can't leave it out. User will select date and output will be according to that.

Well I found out that I have typed the formula wrong which gave the error. My mistake!!
Thank you though..!!

I have recreated the table and uploaded the data into 10g tables.

Thank you so much Maciej....your point no two was a good hint....helped....

that closes all other excel files.

dim fcount as integer

public sub browseFiles()
'browse files and count no of files
fcount=fcount+1
end sub

public sub runMacro()
if fcount >0 then
'do something
end if
end sub


**the two subs run on two different button clicks

Thanks for your support..!! But the requirement is not to call another sub from a sub. They should run on button click by user.

no, i was looking for some simpler solution!

Can not it be done without cookies?

Yes, of course.

inputs:
date1=20-06-2017 01:02:30 am
date2=21-06-2017 01:04:30 am

after subtracting date2-date1, output
00:02:00

It is only calculating the minutes and seconds and not the hours.

My code:

Dim startDateTime, endDateTime As Date

startDateTime = CDate(Form.txtStartTime.Text)
endDateTime = CDate(Form.txtEndTime.Text)

Form.txtDuration.Text = Format((endDateTime - startDateTime), "hh:mm:ss")

I have converted strings into date using CDate(). Could that be a problem?

I see. In all, access is not a good choice for multi user. Thank you for the information..!!

Will you help me understand how can I define the array so that the output is not a string?

I have changed my code as per your code. Still it generates the same value!

The variables are defined at the start and in course of program values are assigned to them through calculation. In the end I am trying to get those values back from them and paste them in cells.

But how to convert it to variable name?

The unhide worked as wonderfully as the hide. Thank you so much..!! First time a problem made me laugh too.

Thank you for your response. Yes, I meant single file. :-)

Thank you for helping with ideas. I will try and get back.

Pardon...it is how to save the text file? I'l edit the question

I have found a work around. To execute the logic separately and then redirecting separately. Since it is part of the answer, I am not marking your answer as solution.

There is logic in emp.logout().

I am not redirecting to aspx directly. The logout method contains some updates and then redirection. So I need to display alert and then move on to the method which includes the redirection.

have tried that also..but as F-ES Sitecore explained, since the html version will be prepared at the end and before that there is redirection, so pop up part will be discarded.

emp.logout redirects to another page. I have to show pop up before calling the method.

Ok...now I got it..!!

Yes, the logout method redirects to another page. I understand..!! Thank you so much!!
What if I display alert before logout method? It is not showing then also.

hey..thanks for your hint....!!

i was seeking help regarding logic...the problem is solved..i will update my proper running code...

Will you please explain with a sample code. My code here goes for first student. But how can I move on to next one?

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.125.136.109:587

This is the error coming now.

I have tried various examples as per your suggestion with gmail. Every time it says "the remote name could not be resolved". When I try pinging gmail.com it says request timed out. Server is in intranet. Could that be a problem?

Also I would like to inform that the server is in intranet network.

Is there any other option?? I will try if there is. I am now trying to send mail using gmail. But it is giving time out error.

After giving permissions, the old error is gone. Now this error is coming:
Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80010001 Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)).

I want to send a mail to user when user clicks a button. That's all. If there is any other way apart from outlook, I'll be glad to try it.

I have given full permission to iis users from outlook command button control properties in DCOM config, as I saw in another solution. But still it is not working. I am not aware of restrictions of sending mail over web. It is working fine in debugging mode.

wow!!it is working now...!!

hey...i tried the code again.
it is giving two errors:
1. Uncaught ReferenceError: $ is not defined on " $(function () {" line.
2. GET http://localhost:12345/jquery.js on "<script src="jquery.js"></script>"

I have thought of this process and it worked. A little lengthy though..It would have to be from code behind since placeholders have variable values.

checked the demo....this is exactly what i wanted... i will go through your demo again and check my own code and revert....

it is not working..!

Let me explain. Suppose on gridview databind there are 3 textboxes in three rows. One has value 3 and other two NA. These values are put while rowdatabound event. Now if a user clicks on textbox containing 3 then 3 will disappear and textbox will be clear to enter new value. If user clicks out of textbox then old value i.e 3 will appear again. So if the user is not interested in changing value, old value will be submitted. In short, user can submit either NA or any number.

actually the user needs to enter value. But default value is NA or values they have entered previously. Now if a user clicks a textbox then it should get clear for him to enter data. Else the old value will be back.

Thank you so much...!!

It worked now!!! Thank you...!! Don't know why there was error before. Must be something I missed..!!

There are multiple conditions. I want the data where manager is mn1 also.

The live demo link that you shared is exactly what I want. Need help with the .css files and in this line:
<input class="easyui-combotree" data-options="url:'tree_data1.json',method:'get'" style="width:100%">

I changed default settings of project to 32 bit in IIS. Now it is working. It is a 'bit' issue.

will it work for 2013?? I installed this only. Still not working.

still it is not working..!! I installed Microsoft Access Database Engine 2010 Redistributable also.....

I removed cache and passed the values to jquery function that calls the service. Now it works..!

I am sorry! I am not aware of such thing for cache. Thank you for the information..!! Actually I have never used service before and what I was basically trying to do was to apply excel autofilter in gridview. The example I followed used service. If there is any other solution to implement the same without service, I will be very happy to accept it.

This is the site I referred:
http://www.dotnettwitter.com/2012/08/filtering-on-each-column-in-gridview-as.html

Hi, I'm afraid this is not what I asked. The data needs to be transferred to a service file (.svc).

thanks...!!

I have posted the solution code in previous reply.

I use the following way: initially visibility of all columns is true.

gv.DataSource = ds.Tables[0];
gv.DataBind();
gv.Columns[7].Visible=false;

Now its working...

still only the header is visible!!

this is rendering an empty column in the middle since there are columns after that column also. Actually, the header is appearing, but the rows are rendering properly

Thanks..!! You made me check web.config once again..!! :-)

the one which is running http://localhost:1609/Service1.svc/data?ColumnName=FNAME gives some id and value pairs on the web page.
the one which is not running http://localhost:61832/Service1.svc/data?ColumnName=FNAME is not giving that output...

Also on running the service page directly for the 'good' project redirects automatically to the .aspx page that uses it. While running .svc file from 'bad' project says "You have created a service. To test this service, you will need to create a client and use it to call the service. You can do this using the svcutil.exe tool from the command line with the following syntax:

svcutil.exe http://localhost:61832/Service1.svc?wsdl

This will generate a configuration file and a code file that contains the client class. Add the two files to your client application and use the generated client class to call the Service."

yes...the one which is giving error...

My mistake..!! I didn't unlock all the cells first..now it works..!!

got it..!!

Yes, it does... :-)

For now, I have thought of and implemented a second way and it is working fine. I just looped through the excel rows and created html table rows accordingly on the fly. I will post the code, if it helps someone. And I will surely go through your hint. Thanks once again.

Thank you Farono....!! It was an error I should have understood..!! Now it's gone but anyway the excel range is not getting pasted yet. So I am not marking your solution as answer because it may mislead users, since question was to paste excel range in outlook mail body.

Thank you Karthik...!!

nope...they are demo data and I typed them in manually....

i modified the query like this:

SELECT [NAMES] FROM CRC WHERE [STATUS]='<div>to</div>'

now, data is getting retrieved but wrapped in <div> tag..!!

Now I am replacing the tags with replace method. Though it is working, it is a very poor way to do so. Help needed.

all the rows and all the columns

I tried selecting * from table and found that whatever data it is retrieving is wrapped in <div> tag..is there anything different in access with C#.net?

hi Karthik...I took up your suggestion of running query removing filter... surprisingly the data is wrapped in <div> tags..!! Like this

<div>abc@xyz.com</div>

thank you Sitecore for answering..yes, I tried running the query in query design in pass through. While running it asks for DNS connection and after creating and trying to use same gives this error - "you cannot use odbc to import from export to or link an external microsoft access or isam database table to your database"..got another problem there..i chose MS Access driver for DNS setup....

well...its not working...!!

ok..i got it...

what is meant by point no 5 & 6??
5. Run the devenv /InstallVSTemplates switch;
6. Run the devenv /Setup switch

Well it says object expected...any idea what object can be missing??

I'll follow your suggestion Andy...

Yes RyanDev...I am expecting September 2...

i am using System.Data.OracleClient. Problem is now solved.

Hello Mika,

What I wanted to do is connect this procedure to dropdownlist at design time through sqlDataSource to show the dept name in the drop down. Just for practice. But there is no option to include function. Is there any way to create procedure for same?

Hi Richard,
Thanks for your reply. But I am using oracle client 9.2.0 which is greater than 8.1.7. Still it is saying to use something else. And debugging is fine.

it was a great help indeed...thank you so much!!

thank u for explaining what it meant.....:-)

Thank you so much!!! It worked...

I tried everything..nothing works...!!

i started the project from file--> new website...can that be a problem?
because when i made a console application from file---> new project, i can change the platform there and it runs fine...but for website only CPU is there and no new platform can be created!!

turning enable 32 bit application true or false in application pool is not helping....

there is a big list in application pool...how to know which is for my project??

Hi...I would like you to know that when I am creating project, I can create new platform in config manager and can add x64 in dropdown and the code runs fine...but when creating website create new platform checkbox is disabled and so solution can't be run....any suggestion/idea why is this happening?

http://i61.tinypic.com/2b5dzs.png

Here is the link of screenshot...
And when I am trying to create new platform, the create new solution platform checkbox is not getting enabled....

http://tinypic.com/view.php?pic=2v3kl84&s=8#.UzehrfmSzBB

Was there something to be done during the installation process??

How can I add a screenshot here?? Then I can show you the dropdown list....

I am using professional edition....the drop down only has Any CPU option..nothing else...how can I select anything else then?

http://msdn.microsoft.com/en-us/library/ms228844(v=vs.90).aspx
this link here says in point 5: "Make sure the Create new project platforms check box is selected. If not, you will have to manage and add the configuration files, any platform dependent code that the wizard can generate for you, and other project files such as resources."
Now in my case the Create new project platforms check box is disabled...also from where can I get the resources??

I have checked it...it is running on 'Any CPU'.....but I do not have any option to change it to x64 or x86...that is my problem....and I cannot add them also....

hi...I could not find any other way so I went with the replace procedure..now insertion can be done without error...but updating a field takes double value..like...if a text box has dog and it has to be updated to cat then updated value is taking 'dog,cat'.....any suggestion for that?

yes..that is the insertion query....no problem in that...
yes I can replace comma with blank space but when there many text boxes, there will be many replacements...I want to avoid that....

thank u.....

Okk...it means I have client installed...now how can I connect oracle 12c to excel 2013?

no I didn't...I have the database in my machine only...so...I used oracle 10g in office 2010...but then I didn't need to install any client..it worked fine with the above code...can you please tell me why will I need it and how to get the software? thank you...

This is my code...

<pre lang="vb">
Dim conn As New ADODB.Connection
conn.Open "DRIVER={MICROSOFT ODBC FOR ORACLE};uid=xyz;pwd=x123".</pre>

And these are references used:
Visual Basic for Applications
MS Excel 15.0 Objct Lib
MS Office 15.0 Objct Lib
Ole Automation
MS Active Data Objects 2.0 Lib

yes it is redirecting....changed only in master page....thank you

yes template is designed using html and css....so links are also html....i want to replace links with aspx links

should i change it in index.html as well?

you added mode="hold" in div....what does that mean?

can you just explain 'mode'?

yes i have used them already...but they are for editing operations....am talking about displaying gridview in editable mode on clicking button....

i didnt bind it twice...they are two different cases...one works...one doesnt...

i hav a question.....

is it necessary to add all columns from the source sheet?? or can selected columns be used??