SQL Insert med variabler - Duer ik
HejJeg har lavet nedenstående if sætning og derefter min Insert SQL sætning som ikke rigtig gider at makke ret, jeg håber der er en af jer der kan hjælpe mig.
DateB = Request.Form("DateB")
StockId = Request.Form("StockId")
Amount = Request.Form("Amount")
AValue = Request.Form("AValue")
CValue = Request.Form("CValue")
Desc = Request.Form("Desc")
If DateB <> "" Then
If StockId <> "" Then
If Amount <> "" Then
If AValue <> "" Then
If CValue <> "" Then
If Desc <> "" Then
SQLStock = "INSERT INTO Stocks (BuyDate, StockId, Amount, AqValue, CurrValue, Desc) VALUES ( "
SQLStock = SQLStock & "#" & DateB & "#, "
SQLStock = SQLStock & "'" & StockId & "', "
SQLStock = SQLStock & "'" & Amount & "', "
SQLStock = SQLStock & "'" & Avalue & "', "
SQLStock = SQLStock & "'" & CValue & "', "
SQLStock = SQLStock & "'" & Desc & "')"
RsStock.Open SQLStock, DSN, 1
Else
Response.Write "Description Field Empty"
End If
Else
Response.Write "Current Value Field Empty"
End If
Else
Response.Write "Aquired Value Field Empty"
End If
Else
Response.Write "Amount Field Empty"
End If
Else
Response.Write "Stock Id Field Empty"
End If
Else
Response.Write "Date Field Empty"
End If
