Lowyat.NET: Latest topics by chaosdreamer

Cannot resolve dns

chaosdreamer — Tue, 19 Feb 2008 14:42:17 +0800

hello,
i'm in quite a big problem. i have another pc that cannot surf internet. the problem is, i can surf if i type an ip address let say yahoo's ip but cannot with yahoo domain. i think this prob because that pc cannot resolve dns. i have done several solutions i found on the net like flushdns, reset tcplog.txt using netsh, set to obtain ip adress automatically but the result still the same. i don't think that this is about the router because i can surf internet using this pc which i'm posting now. so, has anyone encountered this problem before and i would appreciate very much if u can share it with me to solve my problem. thank you.

update: it seems that only firefox cannot resolve dns. i tried with IE works fine.

stuck at sql statement

chaosdreamer — Wed, 02 Jan 2008 12:42:54 +0800

hello,
i'm using php and mysql to develop a system. i'm really stuck at this moment. fyi, i have this table called 'grade' which is for storing information about grades eg. A, B, C+. so i got 3 fields which are 'grade(PK)','gmin' and 'gmax'. 'gmin' is the minimum mark and 'gmax' is the maximum mark. so the problem is, lets say i want to get a grade for 80 which is 'B', how am i suppose to write the sql statement to get that 'B'? i have tried several statement including between but no result appear. really appreciate if someone can help me. thanks.

-----------------------------------
grade | gmin | gmax |
-----------------------------------
A|81|100|
-----------------------------------
B|71|80|
-----------------------------------

Spool Service always crash

chaosdreamer — Thu, 06 Sep 2007 18:28:03 +0800

hello,
is there anyone encountered this spool service crashed after print job finished?i have to start back the service again and again. if not, windows did not detect any printer installed. is it printer's driver problem or windows? fyi, i'm using network printer.

thank you

Split string in ASP.NET 2 (VB)

chaosdreamer — Mon, 09 Jul 2007 12:12:40 +0800

Hello,

I need some help here. I need to split a string like "huhu : haha" into an array then into the database. I'm using ASP.NET 2.0 (VB) with MSSQL 2005. Thanks

Build own backup database page

chaosdreamer — Wed, 13 Jun 2007 11:10:45 +0800

hello,

is there any tutorial that show how to build backup database page using PHP and MySQL?i know it easier using Export in phpMyAdmin but i wanna try develop my own backup page. just simple one by a click on a button then select the location to save. it will then save the whole database. thank you.

checking data

chaosdreamer — Fri, 11 May 2007 23:49:31 +0800

hello,

i have a question to ask. very simple i guess. i have a form that i need to develop. just simple want but the problem is i want to check a data(let say 'username'), i provide the link beside the 'username' textbox to check. so, the user just click that link to check whether the username has been taken or not. so, how can i make a link that send value in the textbox to another page(validation page)?thanks.

username: [___________] check link

Update form

chaosdreamer — Thu, 26 Apr 2007 23:45:41 +0800

hello,

language: PHP
database: MySQL

i need help on how to update the form with several checkboxes in it. lets say i have 20 users in DB and i want to assign the authority level each of them. the form like below:

CODE

Name Level Action
aaa [ ]admin [ ]mod [ ]user UPDATE
bbb [ ]admin [ ]mod [ ]user UPDATE
ccc [ ]admin [ ]mod [ ]user UPDATE
ddd [ ]admin [ ]mod [ ]user UPDATE
.
.
.
.
mmm [ ]admin [ ]mod [ ]user UPDATE

when i click any update link, it will update only the clicked link and update the database for the particular id.

thanks

Split VPN connection

chaosdreamer — Tue, 17 Apr 2007 22:39:41 +0800

i wanna use secureix for torrent and streamyx for surfing. is there any way to split the connection?i have read about split tunneling but i dunno how to do it. just asking. thanks.

setup ftp server

chaosdreamer — Thu, 08 Mar 2007 23:33:26 +0800

hello all,

i had a problem setup my ftp server. it seems that it cannot pass the router although i had my router's firewall disabled (sounds dangerous, i know) and already forwarded the ftp port to my ip. when i type loopback address and my internal ip in the ftp client, it works fine but when i type ext ip, it won't connect. i also tested with my friend outside and tried several times to connect but failed. i had installed several ftp server program like PeerFTP, Serv-U FTP Server and Bulletproof FTP Server but the result all the same. my router is ZyXel Prestige 660H-T1. any help i appreciated.

ZyXel Prestige 660H-T1 problem with torrent

chaosdreamer — Tue, 06 Feb 2007 20:48:18 +0800

hello,
when i open the torrent client and wait a while, i cannot surf the net. when i ping the dns server, sometimes it shows timeout. i had already upgraded to the latest firmware which is V3.40(AGB.1) | 08/08/2006 but the result still the same. for now, i have to limit the global connection below the 100 (i read from somewhere) and it solved a little bit but the torrent is so slow. i need more connections. so, any idea who experienced with this router?

Custom validator

chaosdreamer — Sat, 16 Dec 2006 11:25:19 +0800

hello guys,
i have discovered that ASP.net 1.1 standard validators cannot function properly in mozilla browser because it use DOM technology or i dunno what. so, now i converted all my standard validators into custom one. i've got validation for blank textbox, unselect dropdownlist and compare only. now i need for regular expression to validate email and telephone number. anyone has ideas?

:ASP.NET 1.1
:VB
:VS.NET 2003
:MS ACCESS 2003

i found this interesting article for 1.1 version validation:
http://aspalliance.com/699

cannot connect to database in hosting server

chaosdreamer — Fri, 08 Dec 2006 00:00:00 +0800

i'm currently facing problem with database connection. i dunno how to do anymore with my web.config file. i'm using ms access and ole db provider. mydatabase name is test.mdb and located in db folder. any suggestion?

Tool: VS.Net 2003
Framework: .NET 1.1
Language: ASP.Net/VB
DB: MS ACCESS 2003

CODE

Refresh button reset the page

chaosdreamer — Sun, 26 Nov 2006 12:41:26 +0800

i'm using ASP.net with VB language and MS VS.net 2003 software. i'm encountered this weird problem:
-my page actually act as creating a new card.
-after new card created, all the textboxes are enabled and all DDs are bind from DB.
-the weird things happen when after new card created, when i click refresh button, the page will be reset as the first time loading. all the txtboxes and DDs input are blank.
-i have used the 'If Not Page.IsPostBack Then' also no use. i put the label message just to know if the page is postback or not. first time loading, the label shows Before Postback. after create new card and submit, it shows Postback, after click refresh button, shows Before Postback. it should be a popup window, right?

-then, i created a new web form, copy and paste, turned out to be just fine but after several times debugging the form, a few testing, it came back to the same prob. page reset after clicking the refresh button.
-here is my code for Page_Load:

CODE

'these two are declared outside, above the Page_Load
Dim myCmd As OleDbCommand
Dim conHelpdesk As OleDbConnection

Page_Load....
If Not IsPostBack Then
lblUsername.Text = Session("Username").ToString()

'bind data into DD
Dim strSQL As String

conHelpdesk = New OleDbConnection(ConfigurationSettings.AppSettings("conHelpdesk"))

strSQL = "SELECT Name FROM Info WHERE Level = 1 "

myCmd = New OleDbCommand(strSQL, conHelpdesk)

conHelpdesk.Open()
dropStaffName.DataSource = myCmd.ExecuteReader(CommandBehavior.CloseConnection)
dropStaffName.DataBind()
conHelpdesk.Close()

dropStaffName.Items.Insert(0, "Select Staff Name")
dropStaffName.SelectedIndex = 0

'Pop up windows for confirm appear
btnOpen.Attributes.Add("onclick", "return confirm('Are you sure you want to OPEN? ');")
btnAdd.Attributes.Add("onclick", "return confirm('Are you sure you want to ADD? ');")
btnAddComplaint.Attributes.Add("onclick", "return confirm('Are you sure you want to ADD? ');")

'Insert new item in dropService DD
dropService.Items.Insert(0, "Select the Required Service")
dropService.SelectedIndex = 0

'Insert new item in dropCategory DD
dropCategory.Items.Insert(0, "Select an Item")
dropCategory.SelectedIndex = 0

'Insert new item in dropDetails DD
dropDetails.Items.Insert(0, "Select an Item")
dropDetails.SelectedIndex = 0

lblMessage.Text = "Before PostBack"
Else
lblMessage.Text = "Posted Back"
End If

my behind code for this page have several functions and some datagrid events.
is it prob in my Page_Load or too many functions in one page?

Checkbox and Checkbox List in ASP.net

chaosdreamer — Wed, 22 Nov 2006 17:00:47 +0800

i'm a newbie in ASP.net and i'm stuck on checkbox and checkbox list. i have searched through google but i can't find the useful stuffs about these control. what i want to know now is how to insert multiple data using checkbox list (ex. 3 out of 5). if using checkbox, i have some ideas to go through but it just too long. as for now, i need the coding how to insert multiple data into database using checkbox list. any advices will be appreciated

OS: WinXP SP2
Program: Microsoft Visual Basic .NET
Version: Microsoft .NET Framework 1.1
Language: VB.NET
Databse: MS Access

example:
[x]Scanner
[ ]Printer
[x]Zip Drive
[x]NIC
[ ]Wifi

Problem with D-link DI-604

chaosdreamer — Wed, 19 Jul 2006 19:07:05 +0800

i bought the new DI-604 router and having a problem to connect the internet. the router won't dial even i have clicked the connect button in the status page. i have set the router as follows:
-checked PPPoE
-checked Dynamic PPPoE
-inserted the account's username and password
-checked Always-On
-the rest remain the same

then i clicked apply button and restarted the router. then i went to the status page, i clicked the connect button and wait a while but it can't connect after waited about 5 minutes. FYI, the LAN network works fine and i can access my friend's PC. also, i used wizard still can't overcome this problem.

the weird things is, i went back to the shop and i brought the router and my modem (KASDA provided by Telekom), tested there it worked very well. the technician said he just plugged the modem and router, suddenly it can connect. afterthat, i tried at home without alter any setting, CANNOT CONNECT. weird, huh? anyone can help me i appreciate so much. i'm blank now....

Need help with my Level One FBR-1413TX router

chaosdreamer — Mon, 17 Apr 2006 22:50:52 +0800

it cannot dial to establish connection but the internal network just fine. i can access LAN pc but no internet connection. i have upgrade the firmware again and again but still same. i also have reset the router to default still cannot. the internal network works fine but no internet connection. is someone here has the same problem with me?

Setting up webserver on Lantech HR-117

chaosdreamer — Sun, 16 Apr 2006 11:46:41 +0800

i'm using router Lantech HR-117 and trying to setup a webserver. my problem is i have opened the port 80 to my LAN ip and i have setting up Apache2 webserver but when i enter the WAN ip (also used registered domain name), it went to my router interface. it should be going to my webpage. what should i do now?

thank you