anonīms Posted October 17, 2010 Report Share Posted October 17, 2010 SELECT *, goals+assists AS bomba, ppg/gp AS GAA, shots-ppg AS saves, saves/shots AS SVP FROM speletaji Unknown column 'saves' in 'field list' Kā panākt, lai iegūstu no db šo SVP, kas attiecīgi ir saves(kas no db tiek iegūts kā shots-ppg) dalīts ar shots Kļūda noteikti ir saves/shots AS SVP, bet kādēļ tā, ja es pirms tam esmu norādījis, ka shots-ppg = saves? Ja noņēm saves/shots, tad saves izvada pareizi (shots-ppg AS saves). Kā šo varētu atrisināt? Quote Link to comment Share on other sites More sharing options...
e-remit Posted October 17, 2010 Report Share Posted October 17, 2010 Visticamāk saves/shots AS SVP vietā vajag (shots-ppg)/shots AS SVP jo kolonnas "saves" nav, bet tiek definēta tikai SELECT daļā. Quote Link to comment Share on other sites More sharing options...
anonīms Posted October 17, 2010 Author Report Share Posted October 17, 2010 jap, strādā. Paldies Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.