|
I'm in the process of gathering data for a form
I have 3 tables
1. CompletedOrders
2. BillingAddress
3, Shipping Address
So it works in SQL Manager when I model it, but not in code, asp.net
I just get nothing.
In sql manager, the sa doesn't light up pink, and shows like an error, but doesn't complain.
DECLARE @CompletedOrderID INT;
SET @CompletedOrderID = 3;
DECLARE @CA_ID INT, @BA_ID INT, @SA_ID INT, @CIP_ID INT, @CC_ID INT;
SET @CA_ID = (SELECT CA_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SET @BA_ID = (SELECT BA_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SET @SA_ID = (SELECT SA_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SET @CIP_ID = (SELECT CIP_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SET @CC_ID = (SELECT CC_ID FROM COMPLETEDORDERS WHERE CompletedOrderID = @CompletedOrderID);
SELECT
co.CompletedOrderID
, ba.Attention
, ba.CompanyName
, ba.StreetAddress1
, ba.StreetAddress2
, ba.City
, ba.StateCode
, ba.PostalCode
, ba.CountryCode
, ba.Phone
, sa.Attention
, sa.CompanyName
, sa.StreetAddress1
, sa.StreetAddress2
, sa.City
, sa.StateCode
, sa.PostalCode
, sa.CountryCode
, sa.Phone
FROM COMPLETEDORDERS co
LEFT JOIN CUSTOMER_BILLING_ADDRESS ba ON co.BA_ID = @BA_ID
LEFT JOIN CUSTOMER_SHIPPING_ADDRESS sa ON co.SA_ID = @SA_ID
WHERE co.CompletedOrderID = @CompletedOrderID
|
|
|
|
|
How dumb of me, I set the pointer to ByVal instead of ByRef, wiping out the results.
Time to go home I think
|
|
|
|
|
Those JOINs don't look right. Try:
FROM
COMPLETEDORDERS co
LEFT JOIN CUSTOMER_BILLING_ADDRESS ba ON co.BA_ID = ba.BA_ID
LEFT JOIN CUSTOMER_SHIPPING_ADDRESS sa ON co.SA_ID = sa.SA_ID
You've also got five queries to select a single column from the same record. You could replace that with a single SELECT:
SELECT
@CA_ID = CA_ID,
@BA_ID = BA_ID,
@SA_ID = SA_ID,
@CIP_ID = CIP_ID,
@CC_ID = CC_ID
FROM
COMPLETEDORDERS
WHERE
CompletedOrderID = @CompletedOrderID
;
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I'll try it today or tomorrow, didn't know about the Select and set being able to condense it like that.
Thanks!
|
|
|
|
|
Friends,I am working on a project....and in that project i have to take scanned image of finger with the help of fingerprint scanner.....and this image will be used as a password to log in the site.....so plzzzz..tell me how to store images in database..and how can i check the scanned image of finger of user with other scanned images
|
|
|
|
|
To store an image you will need a parameterized query, but that won't help you with what you are trying to do.
|
|
|
|
|
its web based project....like u can say...whenever we want to login on facebook,gmail,etc.we have to type our alphanumeric password....but i want user to scan his/her fingerprint..and then the fingerprint will be matched(as a password)......so my main aim is to provide more security to users..
|
|
|
|
|
Yes, but I very much doubt that comparing images will work. You'll need to read up on fingerprint matching and such. You're probably better off buying something that will do it for you.
And besides, did your users ask you to do this? I know I wouldn't use a site that did that.
|
|
|
|
|
ook...let me tell u...am a student and its final project which i have to submit...yeah..this project is having wide applications in banking,industries,etc.......
basically i will interface fingerprint scanner with the server.....
|
|
|
|
|
vinay dahiya wrote: i will interface fingerprint scanner with the server.
So when your user wants to logon from home, where exactly is he supposed to place his finger?
|
|
|
|
|
the user have to put his finger on the fingerprint scanner.....
|
|
|
|
|
And how will he do that if the scanner is connected to the server, and the user is at home?
|
|
|
|
|
ook....as i have told u its a project...and it has wide variety of applications in industries and MNCs...........and yeah i just want to show that this can be implemented.....
and yeah the finger print scanner will be with the user(as in case of dell laptops..there is a fingerprint scanner)...and then with the help of that scanner ..scanned image can be given to the server....(and i think this can be done with the help of socket programming)...
|
|
|
|
|
Yes, and there's a reason why they all use their own security-systems, and an even better reason why most sites use a password.
There are existing examples for fingerprint-readers, and if you search you'd also find an SDK. It will work for existing applications, but I doubt that anything like FB or GMail would accept it as an alternative.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
lol....kid...its a project..and yeah i have used name of facebook and gmail as a example.....and i have already told...that i have to do interfacing of electronic with server.......
if u don't have knowledge about this..then don't reply...
|
|
|
|
|
vinay dahiya wrote: if u don't have knowledge about this..then don't reply..
Statements like this are considered abusive on this site. Please remove it.
|
|
|
|
|
he has also used statements like this......" bastard programmer from the hell"...
i think u should see that statement also...
|
|
|
|
|
That was a meme before the word meme existed. It is merely a reference to these[^] stories.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
That is a totally different statement; he is using it to make a comment about himself.
|
|
|
|
|
vinay dahiya wrote: lol....kid..
Thanks for the compliment 
It is a request that comes rather often on this forum, usually from an academic circle. From a webapplication you will not have direct access to the users' hardware.
Good luck btw.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
but will u tell me..that can't i access the ports of pc and then i can take input from the port(using socket programming)..and then that input can be given to the server.......
|
|
|
|
|
What PC? The server or a client?
A webbrowser cannot access the hardware on the client, that would be a security-issue.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
so what should i do now.....????
|
|
|
|
|
Verify that the technical limitation I named actually exists, then find a workaround or an alternative. Better yet, make a list, naming merits and expected problems for each; make prototypes of the best two ideas.
To get you started; you could opt to write a browser-addin (for each type of browser you want to support) that acts as an intermediate, or, you'd write a client-side application (think WinForms/WPF) that provides the same functionality.
The latter will sound like a bad idea to your professor; then again, it would not only be the correct approach; you'd end up with a finger-print protected password-manager. Would not require a dedicated server, as it could run completely (!) on the client. There's no risk in me loosing data, as all my sensitive data never has to leave the client-machine. And best of all, you wouldn't need Google's cooperation to provide the functionality and being able to claim to support GMail.
If you take the latter approach, then you might also want to look up the strategy-pattern. It would be nice if the password-manager also supports other ways of authenticating/authorizing.
That would be targetting a shrinkwrap-application. If your course requires you to write an enterprise-level application, you'd need the first approach.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
thnks....eddy....the all i have to do now...is to think upon some new concept....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
