Comments by Member 9374423

Member 9374423 28-Jan-21 8:15am View

This is very close, but all the "cake" need to appear under Cake, all the "3Cak" need to appear there as well,

Member 9374423 22-Jan-21 2:40am View

Thank you so very much!

Member 9374423 20-Jan-21 8:21am View

So what would this regex look like?

Member 9374423 20-Jan-21 8:20am View

Regex in SQL? I've never heard of this, let me google a bit

Member 9374423 20-Jan-21 8:10am View

Nope, The characters shared can be anywhere, and I don't know the 4 characters before hand, the query must find it, so Lik won't work. Thank you

Member 9374423 22-May-19 2:33am View

that is the test url, the wsdl file is at :

http://training.maxmoney.co.za/MaxAdmin/web_services/?.wsdl

But i cant get that to work either

Also I cant add it using the "Add web service" because there are header records

Member 9374423 11-Apr-17 1:04am View

Hi, on the page I linked it says that the author does not supply support for this anymore.

Member 9374423 11-Apr-17 1:04am View

Hi, on the page I linked it says that the author does not supply support for this anymore.

Member 9374423 11-Apr-17 1:03am View

Hi, on the page I linked it says that the author does not supply support for this anymore.

Member 9374423 10-Mar-14 9:50am View

Hi The specified redeemerID is just an example of one record that returns in the output,

Member 9374423 10-Mar-14 9:01am View

please see the updated question, kind regards

Member 9374423 10-Mar-14 8:54am View

Hi, thank you for the response, however the same issue still occurs...

Member 9374423 10-Mar-14 8:08am View

Hi, The datatypes are both decimal, and the Sum() is not the issue, it has to be the join, when it sums just the amounts as normal, it almost calculates to all the records in that table, even though the next record is less, so every record sums up almost all the records of the table

Member 9374423 10-Mar-14 5:04am View

Hi, thank you for the feedback , but the WHERE (Prepaid.RedeemerID = OneTimePin.WithdrawerID), is exactly the same as an inner join, and i have trid the join, it comes up with the same issue...

Member 9374423 10-Mar-14 5:04am View

Deleted

Hi, thank you for the feedback , but the WHERE (Prepaid.RedeemerID = OneTimePin.WithdrawerID), is exactly the same as an inner join, and I have trithe join, it comes up with the same issue...

Member 9374423 10-Mar-14 5:04am View

Deleted

Hi, thank you for the feedback , but the WHERE (Prepaid.RedeemerID = OneTimePin.WithdrawerID), is exactly the same as an inner join, and i have trithe join, it comes up with the same issue...

Member 9374423 10-Mar-14 5:03am View

Deleted

Hi, thank you for the feedback , but the WHERE (Prepaid.RedeemerID = OneTimePin.WithdrawerID), is exactly the same as an inner join...

Member 9374423 18-Feb-14 7:29am View

This is also not working, it doesn't work on any rows, please elaborate more on the "View State"

Member 9374423 12-Feb-14 4:11am View

Hi, this did not work. Thank you, any other suggestions? Regards

Member 9374423 12-Feb-14 4:08am View

I stated that except for the < , that is the issue

Member 9374423 16-Jan-14 1:51am View

I have ,
with no luck

Member 9374423 20-Dec-13 3:20am View

this resolved the issue with the selects

CREATE TRIGGER IntelligentThinkingDev
ON AuditResults AFTER INSERT
AS

BEGIN
DECLARE @OPTIONID INT
DECLARE @ISoptional INT
SELECT @OPTIONID = OPTIONID FROM INSERTED
SELECT @ISoptional = ISoptional FROM INSERTED

CASE WHEN @optionID = 0 and @ISoptional = 1 THEN
BEGIN
UPDATE AuditResults SET optionid = null WHERE ResultID = (SELECT ResultID FROM INSERTED)
END
END

but I still have an issue with the case error

Member 9374423 20-Dec-13 1:50am View

Thank you, Now I know

Member 9374423 20-Dec-13 0:21am View

Incorrect syntax near the selects and the case?

Member 9374423 5-Dec-13 7:48am View

HiThis is perfect thank you!!!!!!!!!!!

Member 9374423 5-Dec-13 7:40am View

Griff, I ran that code almost 50 times now, exactly as is, on a string field and a datetime field, and it does not work.
If I tell you I am running the code then that's what I'm doing, why would I post an issue and then give the wrong details of what I am doing, I need the issue resolved so i gave you all the details, so we can resolve this.

Member 9374423 5-Dec-13 7:38am View

Ok again it was not my idea, please guys can we focus on the issue here, I was not part of the setup. but I have the issue now.
I have tried the where clause and also tried it without the where clause and it does not work.
I have mentioned this before.
Can anyone please just tell me if there is another way?

Member 9374423 5-Dec-13 7:11am View

I did in the initial file, that's what I'm using

Member 9374423 5-Dec-13 7:03am View

This does not work, are there any other solutions for this?

Member 9374423 5-Dec-13 6:55am View

They have type ID's

Member 9374423 5-Dec-13 6:50am View

The reason is that the varchar field could be any number of values, from names, to dates and so forth

Member 9374423 5-Dec-13 6:49am View

Hi, I do realize this, but the change to that is too significant.
Then the where clause, I have tried with and without a where clause. Both do not work.
Please can you add the code you tried?
Kind regards

Member 9374423 5-Dec-13 6:46am View

I need to update the fields, not run a select

Member 9374423 5-Dec-13 6:38am View

I was not part of the initial developer team, I know this,but there's nothing i can do about that now, haha

Member 9374423 8-Jul-13 5:31am View

i will as soon as i find the answer.

Member 9374423 8-Jul-13 4:58am View

the script will definitely consist of an update with a counter

Member 9374423 8-Jul-13 4:07am View

hmm... this will only set the new column to the same values instead of incrimenting the id's

Member 9374423 5-Jun-13 1:54am View

HI Please see the updated querie

Member 9374423 5-Jun-13 1:54am View

HI Please see the updated querie

Member 9374423 5-Jun-13 1:54am View

HI Please see the updated querie

Member 9374423 4-Jun-13 8:39am View

it was only used as an example.

Member 9374423 4-Jun-13 8:38am View

Great answer only there more than a thousand names to select individually. that would take way to long

Member 9374423 4-Jun-13 8:37am View

Hey I tried the join. and it stil gives the error

Member 9374423 4-Jun-13 8:36am View

still the error I join like the answer above

Member 9374423 4-Jun-13 6:50am View

i do join the two tables.

Member 9374423 4-Jun-13 6:20am View

Hi
I'm sure this code will work, but the "Name" fields actually comes from a different database all together and when i type in [DbPlayers.dbo.tbPlayers.pName], I get an invalid column name error.

Member 9374423 4-Jun-13 6:20am View

Hi
I'm sure this code will work, but the "Name" fields actually comes from a different database all together and when i type in [DbPlayers.dbo.tbPlayers.pName], I get an invalid column name error.

Member 9374423 18-Dec-12 13:21pm View

I want to sort fig 1 so that it looks exactly like figure 2

Member 9374423 18-Dec-12 13:03pm View

SELECT Region,Contact From tblContacts
ORDER BY 1 DESC
Group By Region

this will only order it in alphabetic order, as seen cape town is below the rest of the regions in the below section.

Member 9374423 7-Dec-12 1:31am View

hi I have solved it by adding the insert into C# VIA a "INSERT INTO tblSm ....."
thank you very much for the contribution.

Member 9374423 6-Dec-12 6:40am View

works perfectly once.
but it has to work as it gets refreshed as well.

Member 9374423 5-Dec-12 5:01am View

thank you very much!

Member 9374423 5-Dec-12 4:39am View

so let me make sure i understand you correctly,
the first part I would get the first 2 new lines (line 1 and line 2),using index of.
then get the last 2 Via the lastindex of .
then remove those for?
and then everything inbetween that i would loop a regex through?
then concat it all again?

Member 9374423 5-Dec-12 3:31am View

well just an example of a regex and would you still generate a string list or not?
and if so just an example of the indexing thing please. I have never used them before.

Member 9374423 5-Dec-12 3:30am View

Deleted

well just an example of a regex and would you still generate a string list or not?
and if so just an example of the indexing thing please. I have never used them before.

Member 9374423 5-Dec-12 2:55am View

it makes sense what you are saying. its exactly what i was looking for,however
I have only been doing C# for about a year now.
would you mind giving me a coding example of this.

Member 9374423 4-Dec-12 7:43am View

experienced professionals? did you read the ridiculous answers you gave? next me at least act professional while answering a question. and being sarcastic is not professional.

Member 9374423 3-Dec-12 6:42am View

that will work perfectly. thank you!

Member 9374423 3-Dec-12 6:35am View

that's for an image

Member 9374423 3-Dec-12 6:03am View

you guys are useless. can i please get professional advice?

Member 9374423 3-Dec-12 5:59am View

yes, we have 4 users who can view this data and they wont use anything like that

Member 9374423 3-Dec-12 5:54am View

ok. these clients wont use those tools. we just need basic security.

Member 9374423 3-Dec-12 5:46am View

ok these users arent external, they are allowed to view the data. they just shouldnt be able to modify it or copy it

Member 9374423 3-Dec-12 5:46am View

ok these users arent external, they are allowed to view the data. they just shouldnt be able to modify it or copy it

Member 9374423 3-Dec-12 5:36am View

nope it needs to be simpler

Member 9374423 3-Dec-12 5:24am View

windows.

Member 9374423 3-Dec-12 4:52am View

Nope its an app

Member 9374423 3-Dec-12 4:38am View

never mind i got it

Member 9374423 3-Dec-12 2:54am View

that I know.

I need a separate event for the button btnDateUpdate so taht I can pass the date to it.

Member 9374423 22-Nov-12 8:07am View

Great! thank you very much!

Member 9374423 22-Nov-12 4:22am View

yes, I wont need file streaming,just have to get the file into the database and out again.

Member 9374423 22-Nov-12 3:09am View

I am stuck on starting it up.
I have no idea how this works as this is the first time using it.
I have read through numerous websites, but I still don't understand.

Member 9374423 4-Oct-12 6:02am View

Perfect thank you

Member 9374423 2-Oct-12 6:24am View

Yes,Whenever I create a new project,after a while of editing,it will give the error above

Member 9374423 2-Oct-12 6:15am View

well its actually the solution that's giving the error when I run it

Member 9374423 2-Oct-12 6:03am View

Could you maby give just an example of this?

Member 9374423 2-Oct-12 5:54am View

Please be patient as I am still a junior.

I understand what you are saying. is there a way for me to close all the connections and streams and so on manually?

Member 9374423 2-Oct-12 5:46am View

directory is valid and on my local machine

Member 9374423 2-Oct-12 4:31am View

I have restarted the application and even the computer. the error still occurs

Member 9374423 26-Sep-12 5:05am View

Perfect Thank you

Member 9374423 26-Sep-12 4:50am View

"10070L0022 "
"10070L0022"

when comparing these two,they should be active,but it doesn't add it to the list

Member 9374423 26-Sep-12 4:47am View

Its exactly like that,only the list is way longer and might contain whitespace characters.

Member 9374423 26-Sep-12 4:39am View

yes,then it works,but when I loop through my list it doesn't.

Member 9374423 25-Sep-12 7:18am View

I does not loop properly,for some reason.
It loop until if,then skips a line doesn't add

Member 9374423 25-Sep-12 6:01am View

Hi,It dint work

Member 9374423 25-Sep-12 5:24am View

doesn't work

Member 9374423 25-Sep-12 5:24am View

does not work,It loops forever

Member 9374423 21-Sep-12 5:01am View

No, says invalid colum than

Member 9374423 29-Aug-12 4:21am View

Im Sorry,but could you please explain why you would use the SUM function?

Member 9374423 24-Aug-12 3:28am View

it works fine except when i select the ID field or the first field("Name" in this case) ,any updates?

Member 9374423 24-Aug-12 3:28am View

excatly,two return values

Member 9374423 23-Aug-12 9:56am View

well what can i add in the brackets?

Member 9374423 23-Aug-12 9:51am View

please refference an example

Member 9374423 23-Aug-12 9:50am View

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Connect()

Dim IDnumber2 As Integer = Int32.Parse(IDnumber)

Dim cmdSP As New SqlCommand
cmdSP.CommandText = "spBatchRollBack2 @" & IDnumber2
cmdSP.CommandType = CommandType.StoredProcedure

End Sub

Member 9374423 23-Aug-12 9:50am View

so its a button that needs to get the return values of that Stored procedure

Member 9374423 23-Aug-12 9:50am View

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Connect()

Dim IDnumber2 As Integer = Int32.Parse(IDnumber)

Dim cmdSP As New SqlCommand
cmdSP.CommandText = "spBatchRollBack2 @" & IDnumber2
cmdSP.CommandType = CommandType.StoredProcedure

End Sub

Member 9374423 23-Aug-12 8:33am View

nevermind I got it thank you very much!

Member 9374423 23-Aug-12 8:32am View

what is the dtg your using?

Member 9374423 23-Aug-12 5:20am View

It works Perfectly Thank you very much :}

Member 9374423 23-Aug-12 5:14am View

could you please supply an example?

Member 9374423 23-Aug-12 5:12am View

Hi I do appreciate the help. but could you please rewrite this in VB.net code? it seems to have trouble descripting in VB.

Comments by Member 9374423 (Top 101 by date)