The totally off-topic thread
Page 236.
Discuss The totally off-topic thread, on the Playground forum of FrequentFlyer.com.au, the home of frequent flyers.
Welcome to Australia's leading independent Frequent Flyers resource! We hope you find the information useful and decide to join our online community. Its free to join, simply click on the register link. To start viewing messages, select the forum that you want to visit from the selection below.
Here's one for any programming geeks or freaks here. (I'm one too, but I can't work this one out.)
I use ba97.com to store my flight record online. I was editing stuff the other day and realised Fairchild Metroliner 23 is too big for the Aircraft field. So I tried abbreviating to F'child Metr 23.
The first time I tried this, it didn't work - I got an SQL error. Then, trying to be smart, I tried it again, except I used the Aircraft type as F\'child Metr 23. (I'd learned a few tricks having to deal with SQL in final year IT.)
This worked and it is reflected in my ba97 record. The only problem is that I can't edit anything in my flight record any more. It seems that the ' character is stuffing everything up. An examination of the Javascript error log shows this. I've tried to "intercept" the error using Firebug for Firefox, with no avail. I think the error effectively stuffs up some of the data structures (e.g. the document.forms[] is not initialised).
Using another browser does not get around the problem. Nor can I fiddle with the adding function to overwrite the faulty flight. I've tried some similar SQL tricks whilst trying to add a flight, with no success.
If I knew the .asp code (i.e. diary.asp) then that might be easy to do some deduction, esp. the SQL query code. But of course .asp files are processed server-side before delivery, so no joy to get the source code....
I've emailed the ba97.com admin; not sure if I'll ever get a response.
Anyone got any other ideas? (Apart from abandoning the old account, starting a new one, then reentering all the flights).
... I use ba97.com to store my flight record online. I was editing stuff the other day and realised Fairchild Metroliner 23 is too big for the Aircraft field. So I tried abbreviating to F'child Metr 23. ...
Of course it's really obvious you should have simply entered SWM.
SQL 101 -do not permit the use of characters such a '!
SQL does allow such characters when escaped properly (although on thedatabases I use it is a double apostrophe ''). But \ is also a Javascript escape code!
__________________ Air: QFF Gold Hotel: PC Plat, Hyatt GP: Plat, HH: Silver Car: Avis preferred
On the Road to LTS: 99.5%
SQL does allow such characters when escaped properly (although on thedatabases I use it is a double apostrophe ''). But \ is also a Javascript escape code!
Yes, of course - but it can often lead to problems, some unforseen ...
Yes, of course - but it can often lead to problems, some unforseen ...
Ban their use I say!
You wouldn't be very popular with someone named O'Brien. They always popped that one up on us in final year IT design project.
Anyway, the admins from ba97 got back to me and deleted the offending entry. So profile is back to its springy self with nary a loss. And apparently the ba97 people are looking into the issue.
anat0l 
Linear Mode
