hi guys...
what i want to do is to develop a canvas where user can pick a shape and put in the canvas manipulate it. It's like a microsoft paint software but i want a customize one. anyone has any ideaa how to do that?
Thanks and regards
Ron
Hi guys...
This is the first time i try to code in VBA in Excel. I need to know is there any sample code that read data from MS sperad sheet and input it to oracle database.
I'm new here , your help is very much appreciated
Regards
Ron
Hi,
I try to send message through a network , like thing that you can do using net send command. I use this code:
computer="10.228.202.146"
msgtext="Just a test, please close the screen"
NamUsr="MVT"
Set server_shell = Server.CreateObject("wscript.shell")
server_shell.Run "%comspec% /c...
Hi guys,
i want to get data from a station that link to a pc through a serial port.i'm thinking of writing a visual basic program to communicate to the station( using MScomm) and install the program on the pc.I want everytime data was entered through serial port, the data will be written to a...
H guys,
I want to get the length of database fields (i'm using oracle database) out in the ASP code. i know that the property for field name is .name. what is the property for size?
regards
rOn
guys,
What's my problem actually
this is my code in asp
strinsert="insert into score (badge,score,qid,date) "&_
" values('"&badge&"',"&score&","&qid&",#" & Date() & "#)"
this is the error:
insert into score (badge,score,qid,date) values('12319',3,1,#6/1/2004#)
Microsoft OLE DB Provider for...
Hi guys,
i got this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'table plant_listing where id in('1')'.
/dept/amt/software/fms/myown/update.asp, line 54
and the code is...
Hi guys,
I run this code:
local_name=request("local_name")
if local_name<>"" then
strdetail="SELECT id,local_name,latin_name,other_name,location,desc,origin,usage,sender,picture from "&_
"plant_listing where local_name='"&local_name&"'"
response.Write strdetail
set...
hi guys,
i've run this code:
<%
dim cs
cs="Provider=Microsoft.Jet.OLEDB.4.0;" &_
"DataSource=d:\inetpub\wwwroot\dept\amt\software\fms\myown\plant_listing.mdb;User ID=admin;Password="
Set cn = server.createobject("ADODB.Connection")
cn.open cs
strlocal_name="select distinct...
hi guys,
i've run this code:
<%
dim cs
cs="Provider=Microsoft.Jet.OLEDB.4.0;" &_
"DataSource=d:\inetpub\wwwroot\dept\amt\software\fms\myown\plant_listing.mdb;User ID=admin;Password="
Set cn = server.createobject("ADODB.Connection")
cn.open cs
strlocal_name="select distinct id,local_name...
Hi guys,
Need your help on how to insert data from excel worksheet into oracle database table. I want it to automatically after i click one button. Does anyone has a script that i can reuse??
Thanks and Regards,
Ron
Hi,
Base on data in excel spread sheet, i want to have a button that can insert the data there into a table in oracle. Let assume that the excel column header are the same as fields in oracle table. Please help me to do it.
Thanks and regards,
RoN
hi Guys...
1. I have 3 controls, all radio button namely (opt1,opt2,opt3). options for opt2 are :(A,B,C)
opt3 :(D,E,F) and opt4: (G,H,I)
2. what i want to do is once the user pick any option for opt3, it will return me the control name ( which is opt3). the same goes for the rest. is it...
hi Guys...
1. I have 3 controls, all radio button namely (opt1,opt2,opt3). options for opt2 are :(A,B,C)
opt3 :(D,E,F) and opt4: (G,H,I)
2. what i want to do is once the user pick any option for opt3, it will return me the control name ( which is opt3). the same goes for the rest. is it...
Hi All... ihave the codes below but it will give me this error when i ran it:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/dept/AMT/Software/causes/quality_measurement.asp, line 225
where line 225 is: dpku=no_defect/total_handle * 1000
please help me to rectify what's the...
I have this query that runs slow like hell (event until script time out when running from ASP page) and it take minutes when query from sqlplus prompt. Does any one have ideas to speed up the query? please help me...
SELECT /*+rule*/ count(cause) cause_occ FROM act_item t1,DOWNTIME t2...
Hi...
Let say I have an oracle database table name employee with badge column. sample data for this column are:
badge
-----
00004567
00002345
00012345
00012319
00234567
and i have a string , lets say '4567'. so i just want out information for employee 4567. I try to use this command :
SELECT *...
Thanks for your suggestion..
atually what I want ot do is , lets say i have a string
A="199,20,200,99,9" then when i open a window that list down checkbox for example :
1. ||199
2. ||34
3. ||70
4. ||200
5. ||50
I want checkboxes no 1 and no 4 will be checked cause the value is...
Hi Guys....
Long time never see you all....
actually i have a question ...let say I have a string
stringA="199,99,203,20"
i want to search whether 99 exist in the string or not. I try to use instr(1,stringA,"99") but it return me both 99 and 199 which i dont want. i just...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.