oxida
-
Content Count
52 -
Joined
-
Last visited
-
Copy A File And Rename It With Increment If Exist in VBScript
oxida replied to oxida's topic in Programming
Well I found something simmiliar.It makes a file with a temp name then it changes the .temp extension to .txt.This will be repeated 100 times. Set objFSO = CreateObject("Makefile.FileSystemObject")For i = 1 to 100 ' For Next loop that runs from 1 to 100 strFileName = objFSO.GetTempName 'generates random files names strFileName = Replace(strFileName, ".tmp", ".txt") 'changes .temp to .text strPath = "c:\script\temp\" & strFileName 'path to the location where the files needed to be placed. 'if this script is placed in a folder like: c:\script 'and your strPath is c:\script\temp it 'wil not work it needs a "\" at the end. objFSO.CreateTextFile(strPath) 'creates the fileNext -
Copy A File And Rename It With Increment If Exist in VBScript
oxida replied to oxida's topic in Programming
Travstatesmen, that's exactly what I want to do.Thank you for the info you gave me, the language i wan't it to be written in is: VBscript.I have some really basic knowlage about VBscript and I can simply copy files/folders to the place I want and rename it.But that's where I got stuck.So if someone could help me then I would be so happy.When I'm home I will post the VBscript I have for copy and rename.Thanks again. -
Copy A File And Rename It With Increment If Exist in VBScript
oxida replied to oxida's topic in Programming
Thanks for your reply, but its not what i am looking for. I just want a vbscript wich does only kopie a specified file xx times and name it to: [any name]1, [any name]2, [any name]3 etc etc. I already know how to copy a file one time but thats it. -
This batch file could also be placed in the startup *
-
Hi all.I want to make a VBScript wich does the following:Copy a file like test.txtif test.txt already exists then name it test1.txt and so on until i have xxx number of files.If someone could help me or post a script I would be happy xDThanks,
-
while everything works ok, another problem occurred.When i add another band like: VNV Nation.And when i click on grendel to see the details page, it displays also the band VNV Nation.piece of code for the link, this should send the bandname to the detail page where it selects it from the database. <td colspan="2"><a href="details.php?recordID=<?php echo $row_bands['bandname']; ?>"><?php echo $row_bands['bandname']; ?></a></td> Wholde code of the details.php page. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://forums.xisto.com/no_longer_exists/ xmlns="http://forums.xisto.com/no_longer_exists/ http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Detailed band info</title><link rel="stylesheet" href="style/style.css" type="text/css" /><?php require_once('inc/dbconnection.php'); ?> <?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue;}}$colname_details = "-1";if (isset($_GET['recordID'])) { $colname_details = $_GET['recordID'];}mysql_select_db($database_dbconnection, $dbconnection);$query_details = sprintf("SELECT * FROM bands WHERE bandname = %s ", GetSQLValueString($colname_details, "int"));$details = mysql_query($query_details, $dbconnection) or die(mysql_error());$row_details = mysql_fetch_assoc($details);$totalRows_details = mysql_num_rows($details);$colname_albums = "-1";if (isset($_GET['recordID'])) { $colname_albums = $_GET['recordID'];}mysql_select_db($database_dbconnection, $dbconnection);$query_albums = sprintf("SELECT albumname FROM albums WHERE bandname = %s ", GetSQLValueString($colname_albums, "int"));$albums = mysql_query($query_albums, $dbconnection) or die(mysql_error());//$row_albums = mysql_fetch_assoc($albums);$totalRows_albums = mysql_num_rows($albums);?></head><body><?php do { ?> <fieldset name="Bandinfo" style="width: 600px;"><legend><span style="font-size: 15px; color: #99FF00;"><b>Band info</b></span></legend><table> <tr> <td rowspan="4" style="width: 150px; vertical-align: top;"> <div id="menu-header"> //Options</div> > <a href="add-album.php?recordID=<?php echo $row_details['bandname']; ?>">Add more albums</a> </td> <td><fieldset name="Bandname" style="width: 200px;"> <legend><b>Band Name</b></legend> <?php echo $row_details['bandname']; ?> </fieldset> </td> <td><fieldset name="Bandgenre" style="width: 200px;"> <legend><b>Band Genre</b></legend> <?php echo $row_details['genre']; ?> </fieldset></td> </tr> <tr> <td><fieldset name="Bandmembers" style="width: 200px; height: 200px;"> <legend><b>Band Members</b></legend> <?php echo $row_details['bandmembers']; ?> </fieldset></td> <td><fieldset name="Albums" style="width: 200px; height: 200px;"> <legend><b>Albums</b></legend> <?php while ($r = mysql_fetch_assoc($albums)){$row_albums[] = $r;} foreach ($row_albums as $key => $val){echo $row_albums[$key]['albumname']."<br/>\n";}?> </fieldset></td> </tr> <tr> <td colspan="2"> <fieldset name="Bio" style="width: 427px; height: 200px;"> <legend><b>Biography</b></legend> <?php echo $row_details['bio']; ?> </fieldset></td> </tr> <tr> <td style="text-align: right" colspan="2">[<a href="bands.php">Terug</a>]</td> </tr></table></fieldset> <?php } while ($row_details = mysql_fetch_assoc($details)); ?></body></html><?phpmysql_free_result($details);?>
-
truefusion thanks for your help, it worked well although I don't understand why //$row_albums = mysql_fetch_assoc($albums); displays only a cyou can see the result to klick on the link in one of my posts but i don't think it is necessary .thanks for your time and effort
-
Ok i have pasted the code, It shows this: Array( [albumname] => cool album [0] => Array ( [albumname] => cool album 2 )) To see it in action: Link to bands.php
-
thanks for your fast respond, it seems to work but it mixes up 2 albums because grendel has 2 albums: cool album 1 and cool album 2 when i apply your code it displays: ccool album 2 note: notice the: double c, whish is the first cool album 1 i think. here is the link to see the page in action link to the bands page Klik on grendel to go to the detailed page. here is the code for the page: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://forums.xisto.com/no_longer_exists/ xmlns="http://forums.xisto.com/no_longer_exists/ http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>Detailed band info</title><link rel="stylesheet" href="style/style.css" type="text/css" /><?php require_once('inc/dbconnection.php'); ?> <?phpif (!function_exists("GetSQLValueString")) {function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue;}}$colname_details = "-1";if (isset($_GET['recordID'])) { $colname_details = $_GET['recordID'];}mysql_select_db($database_dbconnection, $dbconnection);$query_details = sprintf("SELECT * FROM bands WHERE bandname = %s ", GetSQLValueString($colname_details, "int"));$details = mysql_query($query_details, $dbconnection) or die(mysql_error());$row_details = mysql_fetch_assoc($details);$totalRows_details = mysql_num_rows($details);$colname_albums = "-1";if (isset($_GET['recordID'])) { $colname_albums = $_GET['recordID'];}mysql_select_db($database_dbconnection, $dbconnection);$query_albums = sprintf("SELECT albumname FROM albums WHERE bandname = %s ", GetSQLValueString($colname_albums, "int"));$albums = mysql_query($query_albums, $dbconnection) or die(mysql_error());$row_albums = mysql_fetch_assoc($albums);$totalRows_albums = mysql_num_rows($albums);?></head><body><?php do { ?> <fieldset name="Bandinfo" style="width: 600px;"><legend><span style="font-size: 15px; color: #99FF00;"><b>Band info</b></span></legend><table> <tr> <td rowspan="4" style="width: 150px; vertical-align: top;"> <div id="menu-header"> //Options</div> > <a href="add-album.php?recordID=<?php echo $row_details['bandname']; ?>">Add more albums</a> </td> <td><fieldset name="Bandname" style="width: 200px;"> <legend><b>Band Name</b></legend> <?php echo $row_details['bandname']; ?> </fieldset> </td> <td><fieldset name="Bandgenre" style="width: 200px;"> <legend><b>Band Genre</b></legend> <?php echo $row_details['genre']; ?> </fieldset></td> </tr> <tr> <td><fieldset name="Bandmembers" style="width: 200px; height: 200px;"> <legend><b>Band Members</b></legend> <?php echo $row_details['bandmembers']; ?> </fieldset></td> <td><fieldset name="Albums" style="width: 200px; height: 200px;"> <legend><b>Albums</b></legend> <?php while ($r = mysql_fetch_assoc($albums)){$row_albums[] = $r;}foreach ($row_albums as $key => $val){echo $row_albums[$key]['albumname'];} ?> </fieldset></td> </tr> <tr> <td colspan="2"> <fieldset name="Bio" style="width: 427px; height: 200px;"> <legend><b>Biography</b></legend> <?php echo $row_details['bio']; ?> </fieldset></td> </tr> <tr> <td style="text-align: right" colspan="2">[<a href="bands.php">Terug</a>]</td> </tr></table></fieldset> <?php } while ($row_details = mysql_fetch_assoc($details)); ?></body></html><?phpmysql_free_result($details);mysql_free_result($albums);?>
-
I have a table called albums it contains the following: the following data is in it albumid bandname albumname0 Grendel test album 11 Grendel test album 22 VNV test album 13 VNV test album 2Now I want to display the albumname from only grendel or vnv or anyother band who comes in the table. How can I do this ??? thanks in advance
-
Need Help With My Database [resolved] retrive data as a link
oxida replied to oxida's topic in Websites and Web Designing
Thank you jlhaslipthis has brought me to use master/detail pages which will do the trick.If i have the page finished i will try to make a tutorial.Because I think it would help a lot of people.*Problem solved* -
Need Help With My Database [resolved] retrive data as a link
oxida replied to oxida's topic in Websites and Web Designing
@jlhaslipi have the following tables:bands with the following rowsbandid, int(10), NOT NULL, AUTO_INCREMENT, PRIMARY KEYbandname, VARCHAR(30), NOT NULLbandsinfo with the following rows:infoid, int(10), NOT NULL, AUTO_INCREMENT, PRIMARY KEYbandinfo, VARCHAR(30), NOT NULLgenre, VARCHAR(30), NOT NULLbio, VARCHAR(30), NOT NULLGenre which is a dropdown box this isnt relevant.@AsgluThx I will try this. -
This is the situation: I have a database where you can add bands ( theire albums, genre other info) For the album part they can add for each album the songs. So what do i want: When i show the results there only shoul display the bandname which should be a link to the more detailed info like albums biography etc. How do I do that. Is there a name for this and are there any tutorials. thx in advance
-
Some things have to get approved first, untill they become visible.So don't worry if it gets approved you/members will see it.greetz,
-
Can't Access My Site An Cpanel already did some sugested things
oxida replied to oxida's topic in Web Hosting Support
Here at Xisto.com My weblink is: http://forums.xisto.com/no_longer_exists/