Click here to Skip to main content
15,925,444 members
Home / Discussions / Web Development
   

Web Development

 
GeneralRe: run exe file from ASP Pin
Paul Watson23-Apr-04 12:51
sitebuilderPaul Watson23-Apr-04 12:51 
GeneralRe: run exe file from ASP Pin
AWebDude25-Apr-04 5:01
AWebDude25-Apr-04 5:01 
Question2 dimensional array??? Pin
doha_8122-Apr-04 17:49
doha_8122-Apr-04 17:49 
AnswerRe: 2 dimensional array??? Pin
Colin Angus Mackay23-Apr-04 8:12
Colin Angus Mackay23-Apr-04 8:12 
GeneralInterDev showing HTML comments in source view Pin
John R. Shaw22-Apr-04 7:56
John R. Shaw22-Apr-04 7:56 
GeneralRe: InterDev showing HTML comments in source view Pin
Paul Watson23-Apr-04 12:56
sitebuilderPaul Watson23-Apr-04 12:56 
GeneralNeed good understaning in the purpose of .lic files Pin
anderslundsgard22-Apr-04 4:12
anderslundsgard22-Apr-04 4:12 
GeneralDISPID_SETSECURELOCKICON event not firing Pin
zero.sg22-Apr-04 2:49
zero.sg22-Apr-04 2:49 
GeneralPop Up size Pin
adilreh22-Apr-04 0:09
adilreh22-Apr-04 0:09 
GeneralRe: Pop Up size Pin
Paul Watson23-Apr-04 12:58
sitebuilderPaul Watson23-Apr-04 12:58 
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 

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.