Help with SQL to create a price check button

V5 Question
42

image
image.png1366×768 35.3 KB

its Not showing anything in the test.

43

Yes, you put your test function in it and click test…

44

image
image.png1366×768 38.9 KB

45

No… like i said…;

Replacing BARCODEHERE with a valid barcode

46

Deffo works i copied and pasted exactly what @JTRTech did and it worked first time, you must have a typo somewhere

47

image
image.png1366×768 41.5 KB

48

OK, so a typo.
C&P your code - dont forget the script button to sprevent stripping by forum.

49

I didn’t really understand what are you saying?

50

When you paste code on forum you should highlight and click this button to post as code as forum can strip some parts.

image

51

And which code do I have to paste?

52

The script…
We cant see it all because it off to the side.
Start by taking the ; semicolon of the last line, dont think its needed on the last line.

53 
function checkPrice(inputBarcode) {
	qry =  "SELECT p.[Price] FROM [MenuItemPrices] p LEFT JOIN [MenuItemPortions] s ON s.[Id] = p.[MenuItemPortionId] LEFT JOIN [MenuItems] m ON m.[Id] = s.[MenuItemId] WHERE m.[Barcode]="+inputBarcode+"AND s.[Name]='Normal'";
	var salesTicketCount = sql.Query(qry).First;
	return salesTicketCount;
}
54

Thats quote rather than code but hay ho.

function checkPrice(inputBarcode) {
qry = “SELECT p.[Price] FROM [MenuItemPrices] p LEFT JOIN [MenuItemPortions] s ON s.[Id] = p.[MenuItemPortionId] LEFT JOIN [MenuItems] m ON m.[Id] = s.[MenuItemId] WHERE m.[Barcode]=”+inputBarcode+“AND s.[Name]=‘Normal’”;
var salesTicketCount = sql.Query(qry).First;
return salesTicketCount
}
55 
function checkPrice(inputBarcode) {
qry =  "SELECT p.[Price] FROM [MenuItemPrices] p LEFT JOIN [MenuItemPortions] s ON s.[Id] = p.[MenuItemPortionId] LEFT JOIN [MenuItems] m ON m.[Id] = s.[MenuItemId] WHERE m.[Barcode]="+inputBarcode+"AND s.[Name]='Normal'";
var salesTicketCount = sql.Query(qry).First;
return salesTicketCount;

}

56

Again;

function checkPrice(inputBarcode) {
qry = “SELECT p.[Price] FROM [MenuItemPrices] p LEFT JOIN [MenuItemPortions] s ON s.[Id] = p.[MenuItemPortionId] LEFT JOIN [MenuItems] m ON m.[Id] = s.[MenuItemId] WHERE m.[Barcode]=”+inputBarcode+“AND s.[Name]=‘Normal’”;
var salesTicketCount = sql.Query(qry).First;
return salesTicketCount
}

image
image752×243 8.22 KB

57 
function checkPrice(inputBarcode) {

qry = “SELECT p.[Price] FROM [MenuItemPrices] p LEFT JOIN [MenuItemPortions] s ON s.[Id] = p.[MenuItemPortionId] LEFT JOIN [MenuItems] m ON m.[Id] = s.[MenuItemId] WHERE m.[Barcode]=”+inputBarcode+“AND s.[Name]=‘Normal’”;
var salesTicketCount = sql.Query(qry).First;
return salesTicketCount
}

58

where is the problem?

59

What does it say on script test?

60

image
image1366×768 38.9 KB

62

I don’t understand what you people trying to say?
Where is the problem?
The script you post on the forum I did exactly copy and paste.