Click here to Skip to main content
15,887,477 members
Home / Discussions / Web Development
   

Web Development

 
Questionhow to change language in a textbox when focused in clientside Pin
amitmerla21-Apr-04 20:41
amitmerla21-Apr-04 20:41 
AnswerRe: how to change language in a textbox when focused in clientside Pin
Paul Watson23-Apr-04 13:02
sitebuilderPaul Watson23-Apr-04 13:02 
Generalcontent management Pin
douxcopine21-Apr-04 20:13
douxcopine21-Apr-04 20:13 
GeneralRe: content management Pin
Vincent Puglia22-Apr-04 7:38
Vincent Puglia22-Apr-04 7:38 
Generalcapturing Ctrl key Pin
Vladimir Kelman21-Apr-04 8:50
Vladimir Kelman21-Apr-04 8:50 
GeneralResize image after upload with asp or component Pin
AngelofPeace20-Apr-04 22:27
AngelofPeace20-Apr-04 22:27 
GeneralRe: Resize image after upload with asp or component Pin
Colin Angus Mackay21-Apr-04 1:18
Colin Angus Mackay21-Apr-04 1:18 
QuestionCan I get the value of newid() function of SQLserver2k from ASP Pin
_skidrow_vn_20-Apr-04 22:20
_skidrow_vn_20-Apr-04 22:20 
ASP & SQLserver2k & Windows2003
I use ASP to add data to 2 tables
I have 2 tables: Invoice and InvoiceDetail
Invoice contains: InvoiceID, ClientName, InvoiceDate........
InvoiveDetail contains: InvoiceID, Name,Price,Quantity....
I set default of InvoiceID(Invoice table)=newid() so I dont need to insert a new value when I add a new record but I can not get value of newid()

Example:
Invoice for Client "Tom"
I use "INSERT Invoice (ClientName, InvoiceDate) VALUES ('Tom','30/1/2004')"
and SQLserver2k auto create a value for InvoiceID such as {BB10687B-87F7-44E4-9397-8D510BBDFA9C}
and then ..... I WANT TO GET {BB10687B-87F7-44E4-9397-8D510BBDFA9C}
I NEED IT to add detail of this invoice for InvoiceDetail table like:

InvoiceID - Name - Price - Quantity
{BB10687B-87F7-44E4-9397-8D510BBDFA9C} - book - 26.5$ - 5
{BB10687B-87F7-44E4-9397-8D510BBDFA9C} - CD - 700.95$ - 1

I think
1) SELECT InvoiceID FROM Invoice WHERE ClientName='Tom' AND InvoiceDate='30/1/2004'" but this is not good, may be duplicate all value in all column
2) May I have to add a new column in table
3) I have to calculate my InvoiceID and not use newid() function of SQLsrv2k Cry | :((

Please help me to get value of newid() function in SQLserver2k

thanks alot
AnswerRe: Can I get the value of newid() function of SQLserver2k from ASP Pin
l a u r e n23-Apr-04 11:25
l a u r e n23-Apr-04 11:25 
Generalaccess to HTMLHelp via intranet Pin
Member 103671620-Apr-04 19:55
Member 103671620-Apr-04 19:55 
GeneralProblem with Isapifilter SendRawData (URGEND) Pin
Stephan Pilz20-Apr-04 2:48
Stephan Pilz20-Apr-04 2:48 
Generalproblem with image "onload"..Pls Help!!! Pin
jithus19-Apr-04 20:33
jithus19-Apr-04 20:33 
GeneralTable Troubles Pin
anonymous1219-Apr-04 17:54
anonymous1219-Apr-04 17:54 
GeneralRe: Table Troubles Pin
Yasen Georgiew20-Apr-04 22:14
Yasen Georgiew20-Apr-04 22:14 
GeneralTransparent background Pin
hkulten19-Apr-04 11:55
hkulten19-Apr-04 11:55 
GeneralASP programmer wants to learn PHP Pin
Hesham Amin17-Apr-04 0:59
Hesham Amin17-Apr-04 0:59 
GeneralRe: ASP programmer wants to learn PHP Pin
Roger Wright17-Apr-04 5:10
professionalRoger Wright17-Apr-04 5:10 
GeneralRe: ASP programmer wants to learn PHP Pin
Vladimir Kelman21-Apr-04 8:48
Vladimir Kelman21-Apr-04 8:48 
GeneralRe: ASP programmer wants to learn PHP Pin
hxxbin22-Apr-04 4:55
hxxbin22-Apr-04 4:55 
Questionhow to increase height upwards and width towards left Pin
nakey_yang15-Apr-04 17:36
nakey_yang15-Apr-04 17:36 
AnswerRe: how to increase height upwards and width towards left Pin
Colin Angus Mackay15-Apr-04 22:40
Colin Angus Mackay15-Apr-04 22:40 
GeneralMultiple Responses Pin
Anonymous15-Apr-04 4:50
Anonymous15-Apr-04 4:50 
GeneralFILE CHECKING Pin
Brendan Vogt15-Apr-04 0:46
Brendan Vogt15-Apr-04 0:46 
GeneralRe: FILE CHECKING Pin
markkuk15-Apr-04 4:38
markkuk15-Apr-04 4:38 
GeneralGetting OpenOffice to the web Pin
locktotten14-Apr-04 0:24
locktotten14-Apr-04 0:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.