khang0001
Active Members-
Posts
27 -
Joined
-
Last visited
khang0001's Achievements
Seeker (1/7)
0
Reputation
-
how can i login hotmail and check mail by fire fox
khang0001 replied to khang0001's topic in AutoIt General Help and Support
I read FF UDF, but hotmail is javascrit, i can`t see any form in page hotmail. help me <!-- ServerInfo: BAYIDSLGN1F40 2011.03.07.16.56.24 Live1 Unknown LocVer:0 --> <!-- PreprocessInfo: BTSA007:RR1BLDA080, -- Version: 10,0,17133,0 --> <!-- RequestLCID: 1033, Market:EN-US, PrefCountry: US, LangLCID: 1033, LangISO: EN --> <html dir="ltr"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"/><base href="https://login.live.com/pp1000/"/><noscript><meta http-equiv="Refresh" content="0; URL=https://login.live.com/jsDisabled.srf?mkt=EN-US&lc=1033"/>Windows Live ID requires Javascript to sign in. This web browser either does not support Javascript, or scripts are being blocked.<br /><br />To find out whether your browser supports Javascript, or to allow scripts, see the browser's online help.</noscript><title>Sign In</title><meta name="description" content="Powerful free e-mail with security from Microsoft - Windows Live Hotmail is a best in class e-mail service that helps you organize and manage all your online stuff in one place"/><meta name="PageID" content="i5030"/><meta name="SiteID" content="64855"/><meta name="ReqLC" content="1033"/><meta name="LocLC" content="1033"/><script type="text/javascript"></script><link rel="image_src" href="Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/Windows_Live_v_thumb.jpg" / > <script type="text/javascript">var g_h=[],g_s=[];g_h["b0"]="This helps protect your information. <a href=\"javascript:DoHelp(\'pleh_ningis\',\'\',\'1033\',\'DH_MSN,1033\',\'\',\'1000\',\'&format=b1\');\" id=\"i1672\">Why?</a>";g_h["b1"]="One Windows Live ID gets you into <b>Hotmail</b>, <b>Messenger</b>, <b>Xbox LIVE</b> — and other Microsoft services.";g_h["b23"]="©2011 Microsoft";g_h["n0"]="Windows Live is not affiliated with and will share with it only an anonymous ID. <a href=\"javascript:DoHelp(\'ni_ngis_driht\',\'\',\'1033\',\'DH_MSN,1033\',\'\',\'1000\',\'&format=b1\');\" id=\"idPaneHelpUniqueIDExplainLink9\">Learn more</a>.";g_h["v27"]="To sign in, enter your email address, insert your smart card, enter your smart card PIN and click <b>Sign in</b>. <a href=\"javascript:DoHelp(\'sdarc_tarms_tuoba\',\'\',\'1033\',\'DH_MSN,1033\',\'\',\'1000\',\'&format=b1\');\" id=\"idPaneHelpEIDExplainLink9\">Learn more</a>";g_h["v28"]="Enter your email address to sign in with your Partner ID. <a href=\"javascript:DoHelp(\'\',\'\',\'1033\',\',1033\',\'\',\'1000\',\'&linktype=2\');\" id=\"idPaneHelpFederationExplainLink9\">Learn more</a>";g_h["v29"]="";g_h["dd3"]="If you\'re signing in from a public computer, you can use a single use code instead of your password for added security. <a href=\"javascript:DoHelp(\'\',\'\',\'1033\',\',1033\',\'\',\'1000\',\'&linktype=3\');\" id=\"idPaneHelpOTCInfoLink9\">Learn more</a>";g_h["dd21"]="Alternate email address must be same as the one you provided during sign up. <a href=\"https://accountservices.passport.net/?wa=wsignin1.0&rpsnv=11&ct=1302098757&rver=6.1.6206.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&cbcxt=mai&snsc=1&vv=1000&mkt=EN-US&lc=1033&id=10\" id=\"idAltEmailRegLink9\" target=\"_blank\">Click here</a> to change your alternate email address.";g_h["dd23"]="Phone number must be the same as the one you registered with Windows Live. <a href=\"javascript:DoHelp(\'\',\'\',\'1033\',\',1033\',\'\',\'1000\',\'&linktype=3\');\" id=\"idPaneHelpOTCInfoLink9\">Learn more</a>";g_h["dd33"]="Your session has timed out. To request a single use code, please <a href=\"javascript:NewOTCRequest()\">refresh the page</a>.";g_h["ll2"]="To sign in again match the characters in the picture. <a href=\"javascript:DoHelp(\'pih\',\'\',\'1033\',\'DH_MSN,1033\',\'\',\'1000\',\'&format=b1\');\" id=\"i1577\">Why?</a>";g_h["y16"]="Your organization #~#partnerdomain#~# does not let its users access this service. Please sign in with a different Live ID or create a new account. <a href=\"javascript:DoHelp(\'\',\'\',\'1033\',\',1033\',\'\',\'1000\',\'&linktype=2\');\" id=\"i1686\">Learn More</a>";g_h["y19"]="You are now required to sign in at #~#partnerdomain#~#.";g_h["y20"]="Not associated with #~#fedbrandname#~#? You must <a href=\"#~#FederationRenameURL_LS#~#\" id=\"i1687\">rename the account</a>." var g_QS="wa=wsignin1.0&rpsnv=11&ct=1302098757&rver=6.1.6206.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&lc=1033&id=64855&mkt=en-us&cbcxt=mai&snsc=1&bk=1302098760";var srf_sBrHdr='';var srf_sBrTtl='Hotmail';var srf_sBrSTtl='##li4##Powerful Microsoft technology helps fight spam and improve security.##li19##Get all your e-mail accounts, calendars, and contacts in one place - even if you use other e-mail services.##li16##New! Chat from your inbox, see what\'s new with friends, and get 5 GB storage that grows when you need it.##BR## ##BR## ##A##Learn more##/A##';var srf_uBrImg='';var srf_sUpLnk='http://mail.live.com/mail/about.aspx';var srf_iHdrCBMode = 1;var srf_iPrdCBMode = 1;var srf_uHdrIFrame = '';var srf_uPrdIFrame = '';var srf_uCustomJS = 'https://secure.shared.live.com/~Live.SiteContent.ID.HMCustomization/~1.0.20/~/~/~/~/mai/SSL/EN-US/header.js?id=64855&mkt=EN-US&cbcxt=mai';var srf_uCobrandingLogo = '';var srf_fValProp=1;var srf_fSignup=1;var srf_oTemplate=new Object();var srf_uPost='https://login.live.com/ppsecure/post.srf?wa=wsignin1.0&rpsnv=11&ct=1302098757&rver=6.1.6206.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&lc=1033&id=64855&mkt=en-us&cbcxt=mai&snsc=1&bk=1302098760';var srf_uRet="http://mail.live.com/default.aspx";var srf_uReg="https://signup.live.com/signup.aspx?ru=http%3a%2f%2fmail.live.com%2f%3frru%3dinbox&wa=wsignin1.0&rpsnv=11&ct=1302098757&rver=6.1.6206.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&lc=1033&id=64855&mkt=en-us&cbcxt=mai&snsc=1&bk=1302098760&cru=https://login.live.com/login.srf%3fwa%3dwsignin1.0%26rpsnv%3d11%26rver%3d6.1.6206.0%26wp%3dMBI%26wreply%3dhttp:%252F%252Fmail.live.com%252Fdefault.aspx%26lc%3d1033%26id%3d64855%26mkt%3den-us%26cbcxt%3dmai%26snsc%3d1";var srf_uFedConv="https://security.live.com/LoginStage.aspx?lmif=1000&ru=https://login.live.com/login.srf%3Fwa%3Dwsignin1.0%26rpsnv%3D11%26ct%3D1302098757%26rver%3D6.1.6206.0%26wp%3DMBI%26wreply%3Dhttp:%252F%252Fmail.live.com%252Fdefault.aspx%26id%3D64855%26cbcxt%3Dmai%26snsc%3D1%26vv%3D1000%26mkt%3DEN-US%26lc%3D1033&wa=wsignin1.0&rpsnv=11&ct=1302098757&rver=6.1.6206.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&cbcxt=mai&snsc=1&vv=1000&mkt=EN-US&lc=1033&cbid=0&id=64855";var srf_uPwRst="https://login.live.com/resetpw.srf?wreply=https://login.live.com/login.srf%3fwa%3dwsignin1.0%26rpsnv%3d11%26ct%3d1302098757%26rver%3d6.1.6206.0%26wp%3dMBI%26wreply%3dhttp:%252F%252Fmail.live.com%252Fdefault.aspx%26id%3d64855%26cbcxt%3dmai%26snsc%3d1%26vv%3d1000%26mkt%3dEN-US%26lc%3d1033&id=64855&mkt=EN-US&lc=1033";var srf_uAbout="http://login.live.com/gls.srf?urlID=WLAbout&mkt=EN-US&vv=1000";var srf_uPrivacy="http://login.live.com/gls.srf?urlID=MSNPrivacyStatement&mkt=EN-US&vv=1000";var srf_uHelp="http://login.live.com/gls.srf?urlID=WLHelpCentral&mkt=EN-US&vv=1000";var srf_uFeedback="http://login.live.com/gls.srf?urlID=WLFeedback&mkt=EN-US&vv=1000";var srf_uTerms="http://login.live.com/gls.srf?urlID=WinLiveTermsOfUse&mkt=EN-US&vv=1000";var srf_uLinkDisclaimer="";var srf_uPinRst="javascript:DoHelp(\'sdarc_tarms_tuoba\',\'\',\'1033\',\'DH_MSN,1033\',\'\',\'1000\',\'&format=b1\');";var srf_uLogin = "https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&ct=1302098757&rver=6.1.6206.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&id=64855&cbcxt=mai&snsc=1&vv=1000&mkt=EN-US&lc=1033";var srf_uRDScript='Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/js/WLFed.js';var srf_uSwUsr='https://login.live.com/logout.srf?wa=wsignin1.0&rpsnv=11&ct=1302098757&rver=6.1.6206.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&lc=1033&id=64855&mkt=en-us&cbcxt=mai&snsc=1&wlsu=1&ru=http://mail.live.com/default.aspx&bk=1302098760&lm=I';var srf_uStUsr="https://login.live.com/ppsecure/secure.srf?wa=wsignin1.0&rpsnv=11&ct=1302098757&rver=6.1.6206.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&id=64855&cbcxt=mai&snsc=1&wa=wsignin1.0&rpsnv=11&ct=1302098757&rver=6.1.6206.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&id=64855&cbcxt=mai&snsc=1&vv=1000&mkt=EN-US&lc=1033&bk=1302098760";var g_urlNoCookies="https://login.live.com/cookiesDisabled.srf?mkt=EN-US&lc=1033";var srf_iForcedCT=0;var srf_sPhoneCodes = 'AR~Argentina~54~^[1-9]{1}[0-9]{10}$~9 343 555 1212~=1, =4, =7!!!AU~Australia~61~^[1-9]{1}[0-9]{8}$~499 123 456~=3, =6!!!BR~Brazil~55~^[1-9]{1}[0-9]{8,9}$~(11) 2345-6789~(=0,) =2,-=6!!!CA~Canada~1~^[1-9]{1}[0-9]{9}$~(604) 555-0100~(=0,) =3,-=6!!!CN~China~86~^1(3[0-9]{9}|[0-9]{10})$~136-8151-8185~-=3,-=7!!!CO~Colombia~57~^([1-9]{1}([0-9]{7}|[0-9]{9})|1[0-9]{10})$~3 315 012345~=1, =4!!!FR~France~33~^[1-9]{1}[0-9]{5,11}$~4 17 91 23 45 67~=1, =3, =5, =7, =9!!!DE~Germany~49~^[1-9]{1}[0-9]{6,10}$~(1 70) 1 23 45 67~(=0, =1,) =3, =4, =6, =8!!!IT~Italy~39~^[1-9]{1}[0-9]{8,9}$~123 456 7890~=3, =6!!!JP~Japan~81~^[A-Za-z0-9_.-]+@([A-Za-z0-9_-]+\.)+[A-Za-z0-9]+$~someone@example.com~!!!MX~Mexico~52~^[1-9]{1}[0-9]{8,9}$~(425) 555-0100~(=0,) =3,-=6!!!NL~Netherlands~31~^[1-9]{1}[0-9]{5,11}$~6 123 45678~=1, =4!!!ES~Spain~34~^[1-9]{1}[0-9]{5,10}$~609 123 456~=3, =6!!!TR~Turkey~90~^[1-9]{1}[0-9]{9}$~5XX 123 4567~=3, =6!!!UK~United Kingdom~44~^[1-9]{1}[0-9]{8,9}$~7123 456789~=4!!!US~United States~1~^[1-9]{1}[0-9]{9}$~(425) 555-0100~(=0,) =3,-=6';var srf_sPrefCountry = 'US';var srf_fOTCEnabled=1;var srf_fShowOTCCredPick=1;var srf_fLateCk=1;var srf_aFedTiers=[2,1];var srf_sFedQS='wa=wsignin1.0&wtrealm=uri:WindowsLiveID&wctx=wa%3Dwsignin1.0%26rpsnv%3D11%26ct%3D1302098757%26rver%3D6.1.6206.0%26wp%3DMBI%26wreply%3Dhttp:%252F%252Fmail.live.com%252Fdefault.aspx%26lc%3D1033%26id%3D64855%26mkt%3Den-us%26cbcxt%3Dmai%26snsc%3D1%26bk%3D1302098760';var srf_iFedState=0;var srf_NonFedDom='.hotmail.,.live.,.msn.';var srf_sNonFedDom=',@hotmail.,@msn.,@live.,@yahoo.,@gmail.,@windowslive.,@sympatico.,@aol.,@163.,@freemail.,@gmx.,@comcast.,@web.,@libero.,@wanadoo.,@sbcglobal.,@example.,@tiscali.,@126.,@mail.,@q.,@xiaoi.,@hanmail.,@walla.,@free.,@ppauthz.com,';var srf_RDAJAX=1;var g_RDHash=1;var srf_fEVUpgrade=1;var srf_uEVUpgrade='https://extended-validation-ssl.verisign.com/dot_clear.gif';var srf_iAutoSSO=0;var srf_fEnInstr=1;var srf_sRBlob='Passpo';var srf_sNUsr='';var srf_sLOpt='';var srf_sMobilePost='';var srf_iCredPostType='';var srf_sPreMn='AmyRobert123@hotmail.com';var srf_sDispMn='AmyRobert123@hotmail.com';var srf_sPreCk='AmyRobert123@hotmail.com';var srf_sFT='<input type="hidden" name="PPFT" id="i0327" value="CcBwqese92AJL5QqczT8OiIxIG4tcyHAnRlz7jIi21qxlWPk16v4TYSOT45LKzrvJgmxW7O2KH7CixsCYZBPZEaZONLlwiiLIhv2WTZDjSwpgeT7IeRCSW4QAOB5T*jn8tKmkmxoFwLgmGzmJ0Wm2LgnMRX4bGTBv0sjo2jIWJ0k4dqci7nRF*rutvkwMnozhR9HUzUQjq2yg9jTfKP5GekzUPC0"/>';var srf_sLCID='1033';var srf_uPreload = '';var srf_uHIPImg="hip.srf?int=login&tm=427670625&id=64855";var srf_uHIPAud="https://login.live.com/hiphelp.srf?int=login&lc=1033&id=64855";var srf_lHIPImgW='168';var srf_lHIPImgH='48';var srf_uImgPath = 'Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/';var srf_uAltImgPath = 'https://secure.wlxrs.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/';var g_DO=new Object;g_DO["compaq.net"]="https://msnia.login.live.com/ppsecure/post.srf";g_DO["hotmail.co.jp"]="https://login.live.com/ppsecure/post.srf";g_DO["hotmail.co.uk"]="https://login.live.com/ppsecure/post.srf";g_DO["hotmail.com"]="https://login.live.com/ppsecure/post.srf";g_DO["hotmail.de"]="https://login.live.com/ppsecure/post.srf";g_DO["hotmail.fr"]="https://login.live.com/ppsecure/post.srf";g_DO["hotmail.it"]="https://login.live.com/ppsecure/post.srf";g_DO["messengeruser.com"]="https://login.live.com/ppsecure/post.srf";g_DO["msn.com"]="https://msnia.login.live.com/ppsecure/post.srf";g_DO["passport.com"]="https://login.live.com/ppsecure/post.srf";g_DO["webtv.net"]="https://login.live.com/ppsecure/post.srf";</script><script type="text/javascript" src="Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/js/Main_WLStrings_JS1033.js"></script> <script type="text/javascript" src="Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/js/WLWorkflow.js"></script> <link rel="stylesheet" title="R3CSS" type="text/css" href="https://secure.wlxrs.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/css/R3WinLive1033.css"/><style type="text/css"> body{display:none;} .cssBtnRest input{background-image: url(Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/btnbkgnd_rest.gif);} .cssBtn input{background-image: url(Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/utbkgnd.gif);} .cssLT{background-image: url(Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/utbkgnd.gif);} .cssLTMore{background-image: url(Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/utbkgnd.gif);} .cssWLGradientIMG,.cssWLGradientIMGSSL{background-image: url(https://secure.wlxrs.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/wave3header.jpg);} .higbutton{background-image: url(Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/btnbkgnd_rest.gif);} .higbuttonblue{background-image: url(Https://secure.shared.live.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/btnbkgnd_hot.gif);} div.cssImage{background: url(https://secure.wlxrs.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/Tile-Image-Background.gif) no-repeat;} div.cssUserImgBkgr{background: url(https://secure.wlxrs.com/~Live.SiteContent.ID/~16.0.2/~/~/~/~/images/UT.png) no-repeat;} </style> <script type="text/javascript">if (top != self){ try{ top.location.replace(self.location.href);}catch (e){ }}else{ document.write(unescape('%3C%73') + 'tyle type="text/css">body{display:block !important;}</style>');}</script></head> <body onload="WLWorkflow();"> </body></html> -
my code is : #Include <FF.au3> If _FFStart("http://ff-au3-example.thorsten-willert.de/",default,2) Then _FFSetValueById("user","Max Mustermann") _FFSetValueById("pass","My_Password") _FFDisConnect() EndIf but it have error : >"C:\Program Files\AutoIt3\SciTE\..\autoit3.exe" /ErrorStdOut "C:\Documents and Settings\XP_PRO\Desktop\autooff\1.au3" _FFConnect: OS: WIN_XP WIN32_NT 2600 Service Pack 2 _FFConnect: AutoIt: 3.3.6.1 _FFConnect: FF.au3: 0.6.0.1b-7 _FFConnect: IP: 127.0.0.1 _FFConnect: Port: 4242 _FFConnect: Delay: 2ms _FFConnect: Socket: 1688 _FFConnect: Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.16) Gecko/20110319 AlexaToolbar/alxf-2.11 Firefox/3.6.16 (.NET CLR 3.5.30729) __FFSendJavascripts: Sending functions to FireFox .......... done _FFOpenURL: http://ff-au3-example.thorsten-willert.de/ __FFSend: try{window.content.top.document.location.href='http://ff-au3-example.thorsten-willert.de/'}catch(e){'_FFCmd_Err';}; __FFRecv: http://ff-au3-example.thorsten-willert.de/ _FFLoadWait: .......... loaded in 2486ms [object XPCNativeWrapper [object HTMLDocument]] — {contentType: "text/html", addEventListener: function() {…}, defaultView: {…}, setUserData: function() {…}, title: "FF.au3 Sample Page", ownerDocument: null, body: {…}, ...} __FFSend: FFau3.WCD=window.content.top.document; __FFRecv: [object XPCNativeWrapper [object HTMLDocument]] — {contentType: "text/html", addEventListener: function() {…}, defaultView: {…}, setUserData: function() {…}, title: "FF.au3 Sample Page", ownerDocument: null, body: {…}, ...} [object XPCNativeWrapper [object HTMLDocument]] — {contentType: "text/html", addEventListener: function() {…}, defaultView: {…}, setUserData: function() {…}, title: "FF.au3 Sample Page", ownerDocument: null, body: {…}, ...} C:\Documents and Settings\XP_PRO\Desktop\autooff\1.au3 (4) : ==> Unknown function name.: _FFSetValueById("user","Max Mustermann") ^ ERROR >Exit code: 1 Time: 4.103 I don`t know what error and how can i repair, please help me
-
I want to get the test and make auto play game to game swf. but i can`t find UDF can help me make that. please help me h can i do it UDF is : user defined function all of you don`t understand me. I play the game flash RPG in My link but I want to make auto play game and get the text in game. how can i do that
-
And sorry I want to import not export, sorry I forget it C:\Documents and Settings\abc\Desktop\1111\test.au3 (27) : ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.: If Not _SQLite_Exec (-1, "INSERT INTO Persons (name,a,b,c,d,e) VALUES ('"&$a[1]&"','"&$a[2]&"','"&$a[3]&"','"&$a[4]&"','"&$a[5]&"','"&$a[6]&"');") = $SQLITE_OK Then MsgBox(16, "SQLite Error", _SQLite_ErrMsg ()) If Not _SQLite_Exec (-1, "INSERT INTO Persons (name,a,b,c,d,e) VALUES ('"&$a[1]&"','"&^ ERROR you code is error. I don`t know problem is mean. please help me. Import test.txt to database
-
my test.txt have data name a b c d e khang 1 2 3 4 5 tuan 6 7 8 9 10 minh 11 12 13 14 15 toan 16 17 18 19 20 tan 21 22 23 24 25 and my code is #include <sqlite.au3> #include <sqlite.dll.au3> #include <file.au3> #include <Array.au3> Local $aResult, $iRows, $iColumns Dim $aArray,$a _SQLite_Startup () If @error Then MsgBox(16, "SQLite Error", "SQLite.dll Can't be Loaded!") Exit - 1 EndIf ConsoleWrite("_SQLite_LibVersion=" &_SQLite_LibVersion() & @CRLF) _SQLite_Open () ; Open a :memory: database If @error Then MsgBox(16, "SQLite Error", "Can't Load Database!") Exit - 1 EndIf $e=1 $b = 1 $i=1 If Not _SQLite_Exec (-1, "CREATE TEMP TABLE persons (name1,name2,name3,name4,name5,name6);") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg ()) for $b = 1 to 5 _FileReadToArray(@ScriptDir & "\test.txt",$aArray) $a = StringSplit($aArray[$b]," ") for $e = 1 to 6 $i=$i+1 If Not _SQLite_Exec (-1, "INSERT INTO persons VALUES ("&$a[$i]&");") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg ()) Next $i=1 Next _SQLite_GetTable (-1, "SELECT * FROM persons;", $aResult, $iRows, $iColumns) _ArrayDisplay($aResult, "Query Result") _SQLite_Close () _SQLite_Shutdown () I want to import test.txt to database sqlite and show in screen . by command _ArrayDisplay but my code not run, help me
-
export 1.txt to database it mean when i have the 1.txt with data is name a b c d e khang 1 2 3 4 5 tuan 6 7 8 9 10 minh 11 12 13 14 15 toan 16 17 18 19 20 tan 21 22 23 24 25 and i want to code to add to my database sqlite auto . ex : open the 1.txt, read data in 1.txt. make database with name is data.db. create the data into data.db. with the command _SQLite_Exec or any command. sorry for my english not good.
-
I have the database sqlite name a b c d e khang 1 2 3 4 5 tuan 6 7 8 9 10 minh 11 12 13 14 15 toan 16 17 18 19 20 tan 21 22 23 24 25 and the code #Include <Date.au3> #include <SQLite.au3> #include <SQLite.dll.au3> FileDelete("Database.db") Dim $hQuery , $aRow _SQLite_Startup () $DatabaseH = _SQLite_Open("Database.db") _SQLite_Exec (-1, "CREATE TABLE iTABLE (name,a,b,c,d,e);") _SQLite_Exec (-1, "INSERT INTO iTABLE (name,a,b,c,d,e) VALUES ('khang','1','2','3','4','5');") _SQLite_Exec (-1, "INSERT INTO iTABLE (name,a,b,c,d,e) VALUES ('tuan','6','7','8','9','10');") _SQLite_Exec (-1, "INSERT INTO iTABLE (name,a,b,c,d,e) VALUES ('minh','11','12','13','14','15');") _SQLite_Exec (-1, "INSERT INTO iTABLE (name,a,b,c,d,e) VALUES ('toan','16','17','18','19','20');") _SQLite_Exec (-1, "INSERT INTO iTABLE (name,a,b,c,d,e) VALUES ('tan','21','22','23','24','25');") $iRval = _SQLite_GetTable2d (-1, "SELECT * FROM persons;", $aResult, $iRows, $iColumns) FileWrite("1.txt",$iRval) how can i import the database in the file 1.txt I try to use the command filewrite but not have any thing. help me. and how can I export the database to the my sqlite same the code _SQLite_Exec thanks you for read my topic. and why forum not have button thanks. i Want to thanks the reply
-
How to search the string in the database
khang0001 replied to khang0001's topic in AutoIt General Help and Support
my database is sqlite in autoit -
How to search the string in the database
khang0001 posted a topic in AutoIt General Help and Support
I have the database name a b c d e khang 1 2 3 4 5 tuan 6 7 8 9 10 minh 11 12 13 14 15 toan 16 17 18 19 20 tan 21 22 23 24 25 I want to search the column and the row ex : if khang and e the result is 5 if tan and c the result is 23 if minh and d the result is 14 please help me how can i search the string in database my database is sqlite -
#include <GUIConstantsEx.au3> Opt("GUIOnEventMode", 1) ; Change to OnEvent mode $mainwindow = GUICreate("Hello World", 200, 100) GUISetOnEvent($GUI_EVENT_CLOSE, "CLOSEClicked") GUICtrlCreateLabel("Hello world! How are you?", 30, 10) $okbutton = GUICtrlCreateButton("OK", 70, 50, 60) GUICtrlSetOnEvent($okbutton, "OKButton") GUISetOnEvent($GUI_EVENT_CLOSE, "CLOSEClicked") GUISwitch($mainwindow) GUISetState(@SW_SHOW) While 1 Sleep(1000) WEnd Func OKButton() GUICreate("next", 500,500,500,500) GUISetState() EndFunc Func CLOSEClicked() If @GUI_WINHANDLE = $mainwindow Then Exit EndIf EndFunc when I click the button OK. It make 1 GUI next. I click 10 times in button Ok. it make 10 Gui next. how can I click 10 times in button OK. and it make 1 GUI next. and how can i close the GUI next independence with GUI hello world. please help meeeeee