|
In SQL Server I was doing this:
IF (record doesn't exists)
RETURN 999
and then I real the value using sqlParameter and Output Type is returnValue..
how can I do the same in mySQL
|
|
|
|
|
|
There's a "Database" forum further down the list of forums on the left.
|
|
|
|
|
Not a C# question, unless they've completely re-designed c# in the last few minutes.
|
|
|
|
|
Wow, you are here for more than 8 years, have already posted more than 500 messages and still haven't figured out, how to find the right forum for a question. 
"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)
|
|
|
|
|
In SQL Server, I was doing this in the stored procedure:
param_record_id int OUTPUT
then I :
set param_record_id = scope_identity()
how can id o the same in mySQL stored procedure?
|
|
|
|
|
And how is this a C# question?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hopefully this one can help. How to get OUT parameter from MySQL
 It didn't even click in me that I wasn't in the db forum... Ignore my answer and put the question in the right place...
I wasn't, now I am, then I won't be anymore.
modified on Tuesday, November 23, 2010 10:35 AM
|
|
|
|
|
Hi,
I have an appointment software using C# WinForm and I want to send alerts (SMS & Emails) through SMS gateways and email to the customers..
I want to know what's best...
1. Send the alert directly from the PC? this will require an internet connection on the PC.
or:
2. Send the alerts to the database on the server and make it in queue? this will not require internet connection to be enabled on every PC.
what do you think?
|
|
|
|
|
This is entirely up to your clients requirements. Personally, I'd go for a more centralized solution, but have no idea what your specs are, the design of the application, what the load is going to be, what the clients restrictions are, ... In other words, you should be asking your client this question, not us.
|
|
|
|
|
my client doesn't talk IT
I have dell server and dell clients
it's a medical software for a clinic with let's say 100 appointments per day
My backend is MySQL and I am using C#.
if you were given this what you will do? will send it from the PC or queue it on the server?
|
|
|
|
|
jrahma wrote: if you were given this what you will do?
I alreay told you what to do. Interviewing the client and gathering detailed requirements is what I'd be doing. Guessing at what the client wants will only get you fired, or not paid when the job is "complete".
I also already told you what my preference would be, but then, I'm not the one coding the app and I'm not the one who's going to pay for it.
|
|
|
|
|
hi
I have homework but I cant solved because I cant install oracle in pc (pl/sql)
this is question print the max salary of emp by function u created in pl/sql
and my teacher want answer in Thursday
|
|
|
|
|
Why can't you install oracle?
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
Oh, there can be quite a few reasons for not being able to install Oracle or getting it running. Have you ever tried it? Then you'd remember the fun with it: e.g. no spaces in path names, extreme requirements for memory and swap files, very complicated processes for creating table spaces, users, schemas, etc. Really stuff from the last millennium, but you need latest hardware!
By the way, there is an "I hate Oracle club": http://forums.thedailywtf.com/forums/17.aspx[^]
|
|
|
|
|
because my os is vista oracal not install in vista
|
|
|
|
|
A few things.
1. We don't do people's homework for them. We aren't trying to pass the course.
2. What has this got to do with C#?
3. Surely you have labs at the school where you can go and try this out.
4. If you have a PC, you can install a cut down version of Oracle.
|
|
|
|
|
Pete O'Hanlon wrote: 3. Surely you have labs at the school where you can go and try this out.
Not necessarily, I can tell you this from first hand experience here. It is very different to the UK....
|
|
|
|
|
I suspect that your teacher expects you to write the function based on the information you have learned in the class. You should not need to install Oracle unless you actually have to test the function as well.
Just say 'NO' to evaluated arguments for diadic functions! Ash
|
|
|
|
|
As the others have said, we don't do homework questions here. If you are having problems getting Oracle installed, I suggest you try the DB formum here, or one of the Oracle specific forums elsewhere.
|
|
|
|
|
Hi,
I'm running my ASP.Net application in 32 - bit, 4 GB RAM server. As because I'm getting large number of hits to my application I'm planning to move to 64 - Bit , 8 GB RAM (running in Virtual Environment).
- Will IIS utilize more RAM and handle large number of hits ?
- What would be the maximum concurrent users that the server can cater?
Thanks in advance ..
|
|
|
|
|
satsumatable wrote: - Will IIS utilize more RAM and handle large number of hits ?
The size of RAM has nothing to do with the number of page views a server can handle. But, yes, 64-bit IIS will use all of the available memory.
satsumatable wrote: - What would be the maximum concurrent users that the server can cater?
Impossible to say. It's determined by the specs of the server, network connections and speed, what the application is doing at the time, what the request involves, ... The only thing that can tell you what the capacity is going to be is to test it using load testing tools, such as IBM's Rational Robot.
|
|
|
|
|
hi me
how to create own messanger programe in WAN as final project
please help
|
|
|
|
|
om_metab wrote: please help
OK. I will help. The first thing you need to do, long before you think about writing any code, is to define your requirements. Work out what the problem is that your application is trying to solve, and write down rough steps that the user would take to solve it. In other words, work out how the user interacts with the problem - this will help to define the use cases of your application. Don't forget to work out what the steps are where the problem diverges - figure out what the alternate steps are in these cases.
Once you have a solid understanding of the problem domain, you will then be able to work out the rough sequences of events that your application has to cope with.
Don't make the mistake of just jumping in and coding - actually design the application. Believe me, your mark will be better because you will be able to show a cohesive solution; you will be able to demonstrate that your application is solving a problem that you understand well, and that you have considered fully. By doing this, you will get a real head start on the code monkeys who simply want us to hand over code to them for nothing.
Be smart. Be a pro. Don't be a monkey.
Good luck.
|
|
|
|
|
thanks MR:Pete O'Hanlon
Iam finsh my project but in LAN I want it in WAN but I did'nt now how to create server
and how user connect to remot server that hold DB of information of user
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
