The following query doesn't work. It seems decode function doesn't like < or > sign inside of it. But I need to compare clients' birth date to another date to get their age then and add them into a age group. Anybody knows how to do this?
select client_id,
decode(birth_date...
Sorry, I tried, but i don't know why it's not working.
At least when this line gets excecuted,
Set db = ws.OpenDatabase("", False, False, strConnect)
Data source window pops up, right?
I need to import data from Oracle database to Access, and I'm already done with it. The connection variable is:
CON = "IN RPD[ODBC;SERVER=aserver;UID=DDDD;PWD=XXXXX]"
The problem is that I have to import more than one tables, and every time when I have sql statement such as:
'COPY...
I need to import data from Oracle database to Access, and I'm already done with it. The connection variable is:
CON = "IN RPD[ODBC;SERVER=aserver;UID=DDDD;PWD=XXXXX]"
The problem is that I have to import more than one tables, and every time when I have sql statement such as:
'COPY...
Sorry, it doesn't seem to work.
Actually, I would need the accountName throughout the pages, so it will be more than 3 pages using it. Shall I define it as global variable? I don't know how global variables work at all.
To simplify my purpose, I have three forms here:
1. contains input field with accountName
<form method="POST" action="choose.php">
2. choose.php, this only processes the data and redirects to other pages according to different account names, this is one of them...
Sorry to bother you guys, i just figured it out. I simply put <A href=\"delete.php?pid=".$row["pid"]."\" onClick=\"javascript:return confirm('Are you sure you want to delete your record?)\"></a> and it worked.
thanks anyways.
Lea
I need exactly the same thing here. But sorry I don't know anything about Javascript, so i don't know how to call onclick. Furthermore, instead of submit button, what i have is a delete image, if user clicks on the image, it calls another page which deletes the record, like:
echo " <A...
Thank you so much for the reply, the function works great except it doesn't include symbols. If i enter http://www.eng.fsu.edu/~aaa, it only convert http://www.eng.fsu.edu/ to hyperlink. I'm a newbie to PHP and none of the books i got discuss this in detail. I greatly appreciate your help and if...
I had a similar problem. I had to delete records and display them in sequence without break, like 1,2,3,4,5,6,7.....continuously. Can I make up an arry, so that every time when
while ($row=mysql_fetch_array($queryresult))
echo " <td width=10% align=center...
Anyone knows what script is like to automatically change a URL to hyperlink so that when a user types a URL in the text field, it changes into hyperlink, like this: http://google.com
Thanks,
Lea
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.