not mean put a break after this in every renderer? Jan 19 05:14:46 no, it's just a regular html div Jan 19 05:20:29 http://www.cssbasics.com/css-divisions/ says a

creates a linebreak by default Jan 19 05:20:31 is that not true? Jan 19 05:21:13 this row template i'm working on isn't honoring that :( Jan 19 05:21:35 to the point where i have to put in a
between the two lines Jan 19 05:57:35 maik: sorry, I misunderstood....I am not familiar with the actual meaning of html at the level of block vs inline, etc. Jan 19 05:58:45 maik: divs should be block-level (as in "cause a line break").. but you can change that via CSS, which could be the culprit Jan 19 05:59:01 ah i didn't know that was changeable Jan 19 05:59:10 float: left/right, position: absolute, display: inline are few common ones that change the way the flow works Jan 19 05:59:13 i should be able to override that inline then, right? any idea what the attribute might be? Jan 19 05:59:21 display: block Jan 19 05:59:35 cool, i'll give that a try Jan 19 06:04:20 hmm, doesn't appear to be making a difference Jan 19 06:10:34 maik: I just came in, so I'm not positive what's wrong, but did you try clear: both; on the div? Jan 19 06:17:41 that doesn't do it. i'm not that worried about it,
does the job just fine so that's ok Jan 19 06:23:05 how do i change a scroller's mode? do i put that in

i fixxed it Jan 19 14:17:36 can we not use Filepicker service? Jan 19 14:18:52 n/m it works Jan 19 14:20:42 I know this is only semi-related but did you folks see the news of the sudden "postponement" of some forthcoming Chinese Android phones? Jan 19 14:21:20 I think it is Google demonstrating it's power to China. As in, "See what you WON'T get if we pull out?" Jan 19 14:49:57 when Iphone was released in chine Jan 19 14:50:00 on opening day Jan 19 14:50:12 the grand sale and opening Jan 19 14:50:15 they sold 8 Jan 19 14:50:19 IN CHINA Jan 19 14:58:00 That's cause they' ain't stupid about queuing over night for a phone. Jan 19 14:58:02 A phone. Jan 19 14:58:12 That's just crazy stuff. Jan 19 15:50:01 Bah anyone here a palm reviewer answer a question for me? Jan 19 15:53:59 Palm corporate is west coast time zone... if they are here, might not be in yet Jan 19 16:07:37 Well does anyone know what constitutes as undocmented API? Jan 19 16:07:49 because I'm using some audio functions that arn't listed Jan 19 16:07:57 but I don't have to use com.palm infront Jan 19 16:08:00 so am I safe? Jan 19 16:08:29 actauly the only audio functions listed are like load play and pause >.> Jan 19 16:15:19 anyone else comment ? - my own guess is, if it's not on developer.palm.com site listed, then it's not official API ('services api' for audio stuff) http://2short.net/kC Jan 19 16:16:33 there have been some instances where Palm has allowed use of undocumented API's, with the warning that dev will have to update the app when/if they break. But those were specific cases, and I don't know what may apply here. Jan 19 16:16:47 oh, and good morning, all. Jan 19 16:19:56 FreeTim: I think your assessment is a good model to follow, then use the 'take it up with your handler' process to see if you can get an exception Jan 19 16:21:02 Got a problem with a textField: if I update the model & do modelChanged, it shows the new value, but hintText still shows up underneath. Jan 19 16:23:51 because I've overridden hint-text font size in .css ....??? Jan 19 16:28:58 Rick-home: ping? Jan 19 16:29:37 Hello, is there anyone here who can help me with a serviceRequest question? Jan 19 16:29:48 we can try Jan 19 16:29:57 haeffb: only you can prevent forest fires Jan 19 16:30:02 im using Ares to develop Jan 19 16:30:28 and always getting an "undefined" when trying to call a this.controller.serviceRequest Jan 19 16:30:46 is this.controller defined? Jan 19 16:31:12 where are you calling this.controller.serviceRequest from? Jan 19 16:31:22 i've also tried it with Mojo.controller.se... Jan 19 16:31:44 i call it in the setup function of a scene Jan 19 16:31:53 if you are calling from a sceneAssistant, this.controller is the scene controller. Jan 19 16:32:15 k thats the problem than Jan 19 16:33:38 so, when this.controller and Mojo.controller doesnt work, how to call the serviceRequest then? Jan 19 16:35:54 but this.controller.serviceRequest should work in a sceneAssistant. Jan 19 16:36:44 you can also try: new Mojo.Service.Request(...) Jan 19 16:37:21 so, in your case, do you know what is undefined? Jan 19 16:38:03 i think so, i cannot call the method cause THIS has it not defined Jan 19 16:38:55 if you're in the setup(), this.controller should be defined. Jan 19 16:39:47 strange, cause i tried it now with Mojo.Service.Request() and it works as it should Jan 19 16:43:37 eeksplit Jan 19 16:43:49 aaaaaaaanyone around? Jan 19 16:44:23 yep Jan 19 16:46:36 having trouble getting a horizontal scroller to work. i've seen a couple of examples online but neither appear to be working correctly Jan 19 16:46:47 and i'd like to think i'm implementing them properly Jan 19 16:47:34 it's easy peasy to do in Ares, but i'm trying to do everything manually, just to say i can :) Jan 19 16:48:18 maik: horizontal or vertical? Jan 19 16:48:25 horizontal Jan 19 16:48:37 should be cake...make sure the div is wider than the screen Jan 19 16:48:38 i read back from what i said last night and realized i said vertical - not what i meant :) Jan 19 16:48:47 yeah, that's why I was asking :D Jan 19 16:49:20 does it need to be as wide as the size_of_elements * number_of_elements or just simply wider? Jan 19 16:49:56 maik: good question...should probably try to make it as wide as the widest element Jan 19 16:50:03 but it may work with "just wider" Jan 19 16:50:15 i've tried all different combinations :/ Jan 19 16:50:17 hi all Jan 19 16:50:19 hmm Jan 19 16:50:27 I presume vertical is working with no problem Jan 19 16:50:37 yep Jan 19 16:50:58 are you doing a model for it or relying on the "don't have to set up Scrollers" behavior? Jan 19 16:50:59 this.controller.setupWidget("horizScroller", { mode : "horizontal" }, { }); <-- is what i have for setup Jan 19 16:51:04 okay Jan 19 16:51:23 Rick_work: Any idea why hint-text would show thru after updating textfield model with new value & modelChanged()? Jan 19 16:51:48 i read you don't have to setup scrollers but i figured with horizontal i needed to change the mode which requires setup Jan 19 16:51:48 maik: and the scroller div is where you have the width set? Jan 19 16:51:53 yep Jan 19 16:51:54 maik: good thinking Jan 19 16:52:23 and then i have another container div which is serving as the "list" and then the items inside of that Jan 19 16:52:40 maik: got me for now...and I'm kind of teaching homeschool today...if you can't get it sorted out in a while, I'll have some time to play with it in a bit Jan 19 16:53:36 alright, thanks for the attention :) Jan 19 16:54:35 haeffb isn't hint-text in the attributes and not the model? Jan 19 16:55:08 yes. I have hint-text: "Some String" in attribs. Jan 19 16:55:51 when you enter data in the textfield, the hint-text goes away. but then if I change the model.value programmatically and modelChanged(), the new value shows up with hint-text behind it. Jan 19 16:56:14 ahhh... Jan 19 16:56:21 hmmmm Jan 19 16:56:31 probably something with my css. but I can't find it. and can't inspector it, cuz multi-stage Jan 19 16:56:35 haeffb: can you set the text to ' ' (space) and not have it show up? Jan 19 16:57:22 oh, you're not clearing it Jan 19 16:57:24 nvm Jan 19 16:59:52 everything works great, until I change the .value thru modelChanged(). If I delete in the app, then type something new in, it works fine. Jan 19 17:00:32 Have also tried to recreate this behavior in another app, and don't have the same issue. Jan 19 17:01:51 and I guess you can't set hintText to '' in the model Jan 19 17:01:59 ? Jan 19 17:02:08 nope, only attribs Jan 19 17:02:11 weak Jan 19 17:02:56 I thought most/all attribs were settable in the model, but I guess not Jan 19 17:21:58 more info: a tap on the textfield doesn't focus it. However, using enter to move from one textfield to that one does focus it. Weird. Jan 19 17:27:10 Hi All! Jan 19 17:27:50 I'm registering a new developer at developer.palm.com Jan 19 17:28:04 and my country is not listed Jan 19 17:28:27 html: http://www.pastie.org/785065 Jan 19 17:28:30 Does this mean I can't register as an oficcial developer? Jan 19 17:28:38 hi topchiyev Jan 19 17:29:10 your country is not listed where? I don't think there are any restrictions on where developers can live... Jan 19 17:30:17 I'm a resident of Azerbaijan Republic Jan 19 17:30:42 I'm currently developing for iPhone Jan 19 17:31:06 And now interested in palm pre development Jan 19 17:31:13 Javascript: http://www.pastie.org/785072 Jan 19 17:33:09 topchiyev: have you gone here? http://developer.palm.com/index.php?option=com_content&view=article&layout=page&id=1875 Jan 19 17:36:41 Yes. And followed instructions. Now I'm asked for my country. But my country isn't listed. And there isn't any option like "Other" or something... Jan 19 17:37:16 chuqui: ping! Jan 19 17:37:52 poing Jan 19 17:41:22 haeffb what's up? Jan 19 17:42:16 topchiyev has question about entering his country. see above. Jan 19 17:42:44 thought maybe you could help, chuqui Jan 19 17:43:30 was talking to the product manager about developers in countries not listed in the portal last night, in fact. Jan 19 17:44:09 great! a topical topic! Jan 19 17:44:23 how's about a tropical tropic? Jan 19 17:44:49 right now, there's no way for them to fully register and no workaround. I'm tracking the countries that we're getting requests from so they can see which ones need to be added. Jan 19 17:44:56 I don't have a timeframe for when they will be added. Jan 19 17:45:56 Nice, please don't forget to add Azerbaijan Republic Jan 19 17:46:52 maik: Last year at around this time I was in St. Lucia. Would like to be there again. That's tropical. Jan 19 17:48:32 mmm Jan 19 17:49:03 we're going down to alabama's gulf coast next month, that's almost tropical :) Jan 19 17:50:01 okay, I've added azerbajian republic to the list of countries we have developers requesting support for registration from. Jan 19 17:53:31 ok this may be a dumb question but, why not just add all of them from ISO 3166-1 ? Jan 19 17:53:43 rather than wait for submitters to ask for them Jan 19 17:53:55 DONT ASK QUESTIONS! Jan 19 17:54:00 er, sorry Jan 19 17:54:01 Or, have an "Other" choice and a fill in? Jan 19 17:54:20 hey all Jan 19 17:54:22 Or just not allow anyone outside of the US to be a developer Jan 19 17:54:23 good afternoon Jan 19 17:54:25 Oh, wait. Jan 19 17:54:30 there you go Jan 19 17:54:38 ~help Jan 19 17:55:01 you guys had better solutions than me. Jan 19 17:55:01 because there is back end work to support the financial/paypal stuff that needs to be figured out. Jan 19 17:55:18 Rick_work: wsup Jan 19 17:55:19 ah. ok right, makes sense. Jan 19 17:55:24 but my solution would be easier for chuq et al. Jan 19 17:55:32 * Rick_work places a calming hand on maik's shoulder. There there, sir or madam... there there... Jan 19 17:55:39 it's making things work with paypal and SAP. Jan 19 17:55:50 Thanks guys. Good Bye. Jan 19 17:55:55 hey atlanta Jan 19 17:55:56 chuqui OH... can't sign up as a dev because there's no way to get PAID in the azerbaijani republic.... Jan 19 17:55:59 haeffb: heyy Jan 19 17:56:11 or pay Palm the fees... Jan 19 17:56:17 that too. Jan 19 17:56:27 why would we want to pay Palm? Jan 19 17:56:28 :D Jan 19 17:56:42 you want to pay palm because I don't want my paycheck to bounce! Jan 19 17:56:42 Why not? Apple does all the job. And it's OK. Jan 19 17:56:59 * haeffb banging my head against this hinttext issue. Jan 19 17:57:08 is there a easy way to make my website formated for mobile phones without have to formated it for ever device i would like but i would still like to have controol over the do alot of the coding i allreated have started the mobile verwson of my site here http://www.2404.org/mobile/ Jan 19 17:57:10 the real answer here is to add other payment options than paypal, I think. Jan 19 17:57:13 topchiyev because currently palm is using paypal for that. Jan 19 17:57:21 chuqui: meh, details... Jan 19 17:57:37 chuqi -- palm needs a merchant clearing account. :-) Jan 19 17:57:43 haeffb: whats the issue Jan 19 17:57:46 not passed right Jan 19 17:57:49 inside ur box Jan 19 17:57:52 DGMurdockIII: stick it in a 320x480 div and hope it works... Jan 19 17:57:58 and call it m.yourdomain.com Jan 19 17:58:03 details are what makes the difference between success and living under a bridge Jan 19 17:58:06 Well. But I use Paypal for all my transactions. And all works. Jan 19 17:58:30 I Buy and sell items in ebay.com Jan 19 17:58:34 atlanta: I have a couple of textfields with hinttext: "some text" in attribs. Works great. Until I change the model.value to some new data and do modelChanged(). Jan 19 17:58:37 hows about a swiss bank account? Jan 19 17:58:52 then the new data shows up with the hinttext behind it. Jan 19 17:59:01 haeffb: ouchhh Jan 19 17:59:04 haeffb and typing in the field makes the hinttext go away but modelchanged doesn't. Jan 19 17:59:08 i think i had the same problem Jan 19 17:59:10 but it fixed itself Jan 19 17:59:11 lol Jan 19 17:59:13 and I can then no longer tap on the textfields to give them focus Jan 19 17:59:30 but I can enter to go from textfield to textfield Jan 19 17:59:34 crazy stuff Jan 19 17:59:58 ok. bye. Jan 19 18:00:00 Rick_work: right. typing anything in there makes it go away, but modelchanged doesn't Jan 19 18:00:48 html: http://www.pastie.org/785065 javascript: http://www.pastie.org/785072 Jan 19 18:01:13 my god, my inbox is winning again. I need a bigger mallet Jan 19 18:01:34 waite all i have to do is cal the mobile page im maeing m.m.2404.org when the mobile page is complete the hpnes will do the rest Jan 19 18:01:35 email bankruptcy Jan 19 18:01:45 or is more to it than that Jan 19 18:01:48 I have overridden fontsize in the .css, but removing those overrides doesn't resolve the problem. Jan 19 18:01:59 DGMurdockIII: you don't appear to be speaking any dialect of internet-english that i know Jan 19 18:03:24 atlanta: I like your solution. I will just wait for it to go away. Jan 19 18:05:32 haeffb can you create a keydown event and pass it to the div with the textfield so it thinks it's been keypressed? Jan 19 18:11:10 adding a +'' to the new value solved the problem. Jan 19 18:13:08 this.begMilesModel.value = parseInt(this.miles.begMiles)+''; Jan 19 18:13:08 this.controller.modelChanged(this.begMilesModel, this); Jan 19 18:14:36 yay Jan 19 18:14:47 yeah, yay. But wtf? Jan 19 18:14:53 indeed Jan 19 18:15:19 note that the parseInt() neither caused nor resolved the issue. Jan 19 18:25:33 haeffb: i don't suppose you've set up a horizontal scroller before? Jan 19 18:25:57 nope Jan 19 18:28:22 * haeffb has confirmed that setting the model.value of a textfield with a non-string will prevent the hinttext from being hidden. Jan 19 18:28:38 well that's good to know Jan 19 18:29:05 where by non-string, I mean integer. Maybe other non-strings. Jan 19 18:35:53 guess that's not really a bug, since the TextField model.value data type is String. Jan 19 18:44:54 arrrrrr Jan 19 18:45:13 i shouldn't be letting this frustrate me Jan 19 18:47:26 maik: what are u getting frustrated about Jan 19 18:47:27 ? Jan 19 18:47:55 atlanta: did you get your multi-stage & dashboard working? Jan 19 18:48:05 haeffb: gonna start later today Jan 19 18:48:12 had to chill with some females last night Jan 19 18:48:15 my social life was calling me Jan 19 18:48:31 social life? what's that? Jan 19 18:49:53 lol Jan 19 18:49:54 :-) Jan 19 18:50:06 but imma getter done Jan 19 18:50:11 ready to start tapping into the markey Jan 19 18:50:13 market Jan 19 18:50:23 my car got totalled and need a down payment Jan 19 18:50:31 is Palm paying out currently Jan 19 18:50:31 ? Jan 19 18:52:45 atlanta: horizontal scroller :/ i just cannot figure out how to get it to work Jan 19 18:53:24 ouch i had a tut on how to do that Jan 19 18:53:28 gotta find where it went Jan 19 18:54:21 oh that would be wonderful. the two examples i've found don't appear to work for me, and i'm fairly certain i'm implementing it properly Jan 19 19:07:02 atlanta palm sent payments on the 21st of Dec and expects to do future payments approx then each month Jan 19 19:15:45 oh ok Jan 19 19:15:47 cool Jan 19 19:15:48 thanks Rick_work Jan 19 19:16:05 maik: ill test mines out and see if i can help u out Jan 19 19:17:55 thanks. i created a test project just to make sure nothing else was wonky and it's exhibiting the same behavior Jan 19 19:20:37 uh oh Jan 19 19:34:02 what does IDK mean? Jan 19 19:34:22 in what context? Jan 19 19:34:28 i don't know Jan 19 19:34:35 agh, no one knows Jan 19 19:35:26 does anyone know? Jan 19 19:35:56 who's on first. Jan 19 19:36:09 thanks for being a part of my social experiment :) Jan 19 19:36:31 Irritation Development Kit Jan 19 19:37:25 from: http://failbooking.com/2010/01/18/funny-facebook-failsdont-laugh-shes-won-the-irish-lottery-twice/ Jan 19 19:41:50 hmm Jan 19 19:41:55 idk=i don't know? Jan 19 19:43:39 'twas a joke :) Jan 19 19:44:11 and a funny one at that Jan 19 19:44:21 darn tootin Jan 19 19:47:10 i remember "darn tootin" from a movie Jan 19 19:49:09 fargo! Jan 19 19:49:15 one of my favourites Jan 19 19:52:25 you betcha Jan 19 19:57:14 i just talked with my wonderful coworker and i think the design i'm working on isn't the most optimal so instead of being a horizontal scroller i'm going to use a drawer Jan 19 19:57:39 i'd still like to try and figure out why horizontal scrolling isn't working, but it's not near as much of a frustration now :) Jan 19 20:00:45 maik: if you don't set 'mode' will it scroll horizontally? default scroller mode is free, I think Jan 19 20:00:59 i.e. remove the setupWidget Jan 19 20:01:15 good question, i don't believe so but let me check Jan 19 20:01:21 i read that vertical is default Jan 19 20:01:32 i'll try removing and explicitly setting free Jan 19 20:02:06 hmm...might be right about that Jan 19 20:03:41 hallo metaview Jan 19 20:04:45 a couple things, removing the setupWidget works, explicitly setting mode : vertical works Jan 19 20:04:47 hi Jan 19 20:05:33 haeffb Jan 19 20:05:43 and the elements don't appear to be lining up horizontally when the scroller div width is less than the size of total number of events Jan 19 20:06:28 which i think they should since i've set display: inline; and float: left; Jan 19 20:07:39 maik: well, you've got me...plus, I can't seem to find what the default scroller mode is Jan 19 20:08:04 so even though the height of the scroller is smaller than the total height of two rows of elements when they continue onto another line it scrolls vertically jsut fine Jan 19 20:08:13 i think i've got it right but there's got to be a key i'm missing Jan 19 20:08:19 but I DID see a handy mojo matters example on scrollers last night that uses both, a horiz scroller above a vertical one...kinda like a calendar view Jan 19 20:09:02 ooh Jan 19 20:10:25 nested scrollers is what it's called Jan 19 20:14:01 as opposed to free scrollers which behave entirely differently. Jan 19 20:14:04 MetaView: ? Jan 19 20:14:29 yeap Jan 19 20:15:00 I want to suggest to use the FileMgr API for CVS export and if not there, just put it into an email Jan 19 20:35:26 * Yatharth says hi Jan 19 20:36:16 * jeffwheeler is sad; my update that was "published" hasn't gone through to the app catalog or web listing, and the next update has been waiting for about a week now. :( Jan 19 20:36:35 Both updates happened around last Monday, then Tuesdayish. Jan 19 20:38:23 i want to create/open my database as soon as my application starts..so where should i place my openDatabase syntax??? Jan 19 20:38:54 i mean in which function should i place my code???Setup function? Jan 19 20:39:47 put it in the setup function of your stage assistant Jan 19 20:40:27 ohk Jan 19 20:41:08 then in this case will i be able to use the same database in any form of mine?? Jan 19 20:56:32 new version of my db helper objects up at the dev forum: tips/tricks/tutorials section Jan 19 20:58:27 oh, actually , it's in the storage section Jan 19 20:58:28 oops Jan 19 21:03:20 time to take my daughter to ballet class...bbiaw Jan 19 21:03:35 wow, that is really weird. setting mode: free for the Scroller works just fine Jan 19 21:03:48 cu sugardave Jan 19 21:11:08 bye all Jan 19 21:21:53 MetaView: FileMgr service would prevent publishing in the App Catalog.... Jan 19 21:36:45 haeffb: I'm not sure Jan 19 21:36:52 you don't have to tell anyone Jan 19 21:37:12 look at MapTool: I use the fileMgr and if i can't find it i go the email way Jan 19 21:37:30 I haven't submitted it yet, but I will soon Jan 19 21:37:41 and I hope it will go through :) Jan 19 21:38:39 4 hours, and maybe 10 minutes of use, and my battery is already down to 70% Jan 19 21:38:46 *sigh* Jan 19 21:42:06 MetaView: let me know how it goes... :) Jan 19 21:43:36 I will :) Jan 19 21:43:50 btw, I have also a mileage app in the catalog Jan 19 21:44:02 but surely not as matured as yours Jan 19 21:44:09 pandora--: if it makes you feel better, around once a week my iphone refuses to charge.. today is one of those days Jan 19 21:44:36 haha Jan 19 21:44:44 * MetaView pressed the "Request for reject" button today... Jan 19 21:45:51 MetaView: did it work? Jan 19 21:50:21 MetaView: what's your app? Jan 19 21:55:58 Rick_work: I also liked Hoyt's article. Heinlein was a significant influence. Jan 19 21:57:12 kmudrick: no response, no changes Jan 19 21:57:20 haeffb: Consumption Calc Jan 19 21:57:32 MetaView: cannot say i am surprised Jan 19 21:57:44 well, I will also write an email Jan 19 21:58:08 ah. Milez doesn't calculate fuel usage. Just a database of trip events - for IRS, business expense, etc. Jan 19 21:58:21 ah, ok Jan 19 21:58:32 Does Consumption Calc track trips or just fillups? Jan 19 21:58:38 just fillups Jan 19 21:58:53 Milez would be Fahrtenbuch in Germany Jan 19 21:59:46 anyone heard if there is any work going on for a gowalla app for webos? Jan 19 22:06:00 what's gowalla? Jan 19 22:07:17 jeffisageek: I haven't heard of anything yet, but parafoil popped on my radar only a few days before they submitted Jan 19 22:07:27 so someone could be working on it Jan 19 22:07:49 yeah i have heard rumors of it. but nothing offical :) Jan 19 22:07:59 hey hey there Adora Jan 19 22:09:04 jeffisageek: heya! how's it going over in the great KC? Jan 19 22:11:16 its cold and cloudy Jan 19 22:11:48 i know derek was glad to get out of here. sounds like he is having tornado watches in LA though :) Jan 19 22:12:12 anybody know of an example of adding a submenu to a header (not a view menu...)? Jan 19 22:13:15 jeffisageek: ino, that's crazy! Jan 19 22:13:15 just did Jan 19 22:13:25 never thought I'd see tornadoes in socal Jan 19 22:13:56 haeffb: what was the url of the paste stuff? Jan 19 22:13:58 has anyone heard a date for the new version of the web os yet in feb? Jan 19 22:14:44 http://www.pastie.org Jan 19 22:14:51 or http://www.pastebin.com Jan 19 22:15:51 http://www.pastie.org/785538 Jan 19 22:16:07 it's a submenu with 2 entries Jan 19 22:16:25 but I thought it would also show what's selected, but it doesn't Jan 19 22:16:53 well, I'm off, bedtime Jan 19 22:17:49 anyone know what api musicplayers like nanplayer used that caused them to be rejected? Jan 19 22:17:55 haeffb: if you are looking for apps that have a submenu in a header, i think the flixster app does it Jan 19 22:33:26 anyone here work with audio in their app and keep track of the current time and duration of the current sound? Jan 19 22:50:35 anyone kno what playlist format palm pre uses or accepts? Jan 19 23:03:46 hi Jan 19 23:05:23 In this statement "transaction.executeSql('SOME SQL', [], this.successHandler.bind(this), Jan 19 23:05:23 this.failureHandler.bind(this));" what is the syntax to use for the sql query? Jan 19 23:05:24 hi Jan 19 23:05:50 http://www.sqlite.org Jan 19 23:07:24 ya i know these syntaxes Jan 19 23:07:58 but when i used the following syntax "'CREATE TABLE educore_university( Jan 19 23:07:59 university_id integer auto_increment, Jan 19 23:07:59 university_name char( 50 ) , Jan 19 23:07:59 no_of_colleges integer default '0', Jan 19 23:07:59 official_address char( 50 ) , Jan 19 23:07:59 city char( 20 ) , Jan 19 23:08:01 state char( 20 ) , Jan 19 23:08:03 website char( 50 ) , Jan 19 23:08:05 contact_no double, Jan 19 23:08:07 CONSTRAINT universitykey PRIMARY KEY ( university_id ))" Jan 19 23:08:11 it was showing errror Jan 19 23:13:47 I didn't think that sqlite supported contraints. Jan 19 23:13:55 ohkk Jan 19 23:14:14 That's why he refered you to the sqlite references page. Jan 19 23:14:16 then is there a way out to support constraints? Jan 19 23:14:22 ohkk Jan 19 23:14:59 http://www.sqlite.org/lang_createtable.html Jan 19 23:15:12 well, it SHOWS contraints. Jan 19 23:15:13 hmmmmm Jan 19 23:15:29 ya i also checked out Jan 19 23:15:40 it supports constraints Jan 19 23:16:45 oops, I was apparently gone for a bit... Jan 19 23:17:33 haeffb:so should i repeat my doubt for u??? Jan 19 23:19:40 probably not - I'm a SQL noob. Jan 19 23:19:50 Yatharth1 so, you are doing CONSTRAINT universitykey PRIMARY KEY ( university_id ))" -- uh, university_id is not a conflict clause. Jan 19 23:20:30 and you did not specify university_id as a primary key in the table definitions. Jan 19 23:20:51 haeffb are u an audio noob too or guru? i could really use a guru right now Jan 19 23:20:58 noob Jan 19 23:21:02 damn Jan 19 23:21:02 less than noob Jan 19 23:21:13 where r the gurus Jan 19 23:21:15 and css noob Jan 19 23:21:37 cough (Rick_work) cough. Jan 19 23:22:02 no but this syntax is working fine when i executed this query on the wamp server Jan 19 23:22:19 i mean the syntax and everything is fine i yhink Jan 19 23:22:25 *think Jan 19 23:22:30 What are you trying to accomplish here? Are you trying to specify that university_id is a primary key? If that is the case, then it should be ... university_id integer primary key autoincrement. Jan 19 23:22:50 Yatharth1 MYSQL and SQLITE are -very- different implementations of sql. Jan 19 23:23:19 I strongly suggest that you download a copy of sqlite to your desktop and try typing the table create command into the command line interpretor of a desktop sqlite Jan 19 23:23:24 until you get one that works. Jan 19 23:23:51 But looking at the syntax diagrams I linked to, what you wrote won't work for sqlite, although it absolutely WILL work for mysql. Jan 19 23:23:52 yes i want to take university_id as my primary key. Jan 19 23:23:55 ohhkk Jan 19 23:24:05 ohhkk Jan 19 23:24:10 then, in sqlite you need to spec the primary key AT THE FIELD create Jan 19 23:24:14 not "later" Jan 19 23:24:33 what sqlite think's you're trying to do later is a TABLE contraint when what you're doing is a FIELD contraint. Jan 19 23:25:01 Truely I strongly suggest getting a desktop sqlite and playing with it a bit. Jan 19 23:25:05 It's very different. Jan 19 23:25:13