spidey78
Posts: 9
|
| Posted: 11/12/2007, 5:30 PM |
|
I got the code charge file database done where I turned a ms access file into a html database and it works the way that I want it, now what I am wondering is how do I take it and add it to my website. I guess what I am wondering is when I take the file out of codecharge and move it to my website how does it reference the ms access database file and how do I set it up to act like it does in code charge. I am adding the codecharge code below. I hope this is not too general. thanks for the help.
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=windows-1252">
<title>NewPage1</title>
<meta content="CodeCharge Studio 3.2.0.4" name="GENERATOR">
<link href="Styles/Apricot/Style.css" type="text/css" rel="stylesheet">
</head>
<body>
<!-- BEGIN Record Sheet1Search -->
<form name="{HTMLFormName}" action="{Action}" method="post">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td valign="top">
<table class="Header" cellspacing="0" cellpadding="0" border="0">
<tr>
<td class="HeaderLeft"><img src="Styles/Apricot/Images/Spacer.gif" border="0"></td>
<th>Search Sheet1 </th>
<td class="HeaderRight"><img src="Styles/Apricot/Images/Spacer.gif" border="0"></td>
</tr>
</table>
<table class="Record" cellspacing="0" cellpadding="0">
<!-- BEGIN Error -->
<tr class="Error">
<td colspan="2">{Error}</td>
</tr>
<!-- END Error -->
<tr class="Controls">
<th>Organization</th>
<td><input maxlength="250" size="50" value="{s_Organization}" name="{s_Organization_Name}"></td>
</tr>
<tr class="Controls">
<th>Sort by</th>
<td>
<select name="Sheet1Order">
{Sheet1Order_Options}
</select>
<select name="Sheet1Dir">
{Sheet1Dir_Options}
</select>
</td>
</tr>
<tr class="Bottom">
<td align="right" colspan="2">
<!-- BEGIN Button Button_DoSearch --><input type="image" src="Styles/Apricot/Images/en/ButtonSearch.gif" value="Search" border="0" name="{Button_Name}"><!-- END Button Button_DoSearch --></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<!-- END Record Sheet1Search --><br>
<!-- BEGIN Grid Sheet1 -->
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td valign="top">
<table class="Header" cellspacing="0" cellpadding="0" border="0">
<tr>
<td class="HeaderLeft"><img src="Styles/Apricot/Images/Spacer.gif" border="0"></td>
<th>List of Sheet1 </th>
<td class="HeaderRight"><img src="Styles/Apricot/Images/Spacer.gif" border="0"></td>
</tr>
</table>
<table class="Grid" cellspacing="0" cellpadding="0">
<tr class="Caption">
<th>
<!-- BEGIN Sorter Sorter_Organization --><a href="{Sort_URL}">Organization</a>
<!-- BEGIN Asc_On --><img src="Styles/Apricot/Images/Asc.gif" border="0"><!-- END Asc_On -->
<!-- BEGIN Desc_On --><img src="Styles/Apricot/Images/Desc.gif" border="0"><!-- END Desc_On --><!-- END Sorter Sorter_Organization --></th>
<th>
<!-- BEGIN Sorter Sorter_Org_City --><a href="{Sort_URL}">Org City</a>
<!-- BEGIN Asc_On --><img src="Styles/Apricot/Images/Asc.gif" border="0"><!-- END Asc_On -->
<!-- BEGIN Desc_On --><img src="Styles/Apricot/Images/Desc.gif" border="0"><!-- END Desc_On --><!-- END Sorter Sorter_Org_City --></th>
<th>
<!-- BEGIN Sorter Sorter_State --><a href="{Sort_URL}">State</a>
<!-- BEGIN Asc_On --><img src="Styles/Apricot/Images/Asc.gif" border="0"><!-- END Asc_On -->
<!-- BEGIN Desc_On --><img src="Styles/Apricot/Images/Desc.gif" border="0"><!-- END Desc_On --><!-- END Sorter Sorter_State --></th>
</tr>
<!-- BEGIN Row -->
<tr class="Row">
<td><a href="{Organization_Src}">{Organization}</a> </td>
<td>{Org_City} </td>
<td>{State} </td>
</tr>
<!-- END Row -->
<!-- BEGIN NoRecords -->
<tr class="NoRecords">
<td colspan="3">No records</td>
</tr>
<!-- END NoRecords -->
<tr class="Footer">
<td colspan="3"><a href="{Sheet1_Insert_Src}">Add New</a>
<!-- BEGIN Navigator Navigator -->
<!-- BEGIN First_On --><a href="{First_URL}">First</a> <!-- END First_On -->
<!-- BEGIN First_Off -->First <!-- END First_Off -->
<!-- BEGIN Prev_On --><a href="{Prev_URL}">Prev</a> <!-- END Prev_On -->
<!-- BEGIN Prev_Off -->Prev <!-- END Prev_Off -->
<!-- BEGIN Pages -->
<!-- BEGIN Page_On --><a href="{Page_URL}">{Page_Number}</a> <!-- END Page_On -->
<!-- BEGIN Page_Off -->{Page_Number} <!-- END Page_Off --><!-- END Pages -->of {Total_Pages}
<!-- BEGIN Next_On --><a href="{Next_URL}">Next</a> <!-- END Next_On -->
<!-- BEGIN Next_Off -->Next <!-- END Next_Off -->
<!-- BEGIN Last_On --><a href="{Last_URL}">Last</a> <!-- END Last_On -->
<!-- BEGIN Last_Off -->Last <!-- END Last_Off --><!-- END Navigator Navigator --></td>
</tr>
</table>
</td>
</tr>
</table>
<!-- END Grid Sheet1 --><br>
<!-- BEGIN Record Sheet2 -->
<form name="{HTMLFormName}" action="{Action}" method="post">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td valign="top">
<table class="Header" cellspacing="0" cellpadding="0" border="0">
<tr>
<td class="HeaderLeft"><img src="Styles/Apricot/Images/Spacer.gif" border="0"></td>
<th>Add/Edit Sheet1 </th>
<td class="HeaderRight"><img src="Styles/Apricot/Images/Spacer.gif" border="0"></td>
</tr>
</table>
<table class="Record" cellspacing="0" cellpadding="0">
<!-- BEGIN Error -->
<tr class="Error">
<td colspan="2">{Error}</td>
</tr>
<!-- END Error -->
<tr class="Controls">
<th>Last Name</th>
<td><input maxlength="250" size="50" value="{Last_Name}" name="{Last_Name_Name}"></td>
</tr>
<tr class="Controls">
<th>First Name</th>
<td><input maxlength="250" size="50" value="{First_Name}" name="{First_Name_Name}"></td>
</tr>
<tr class="Controls">
<th>Org Address</th>
<td><input maxlength="250" size="50" value="{Org_Address}" name="{Org_Address_Name}"></td>
</tr>
<tr class="Controls">
<th>Org City</th>
<td><input maxlength="250" size="50" value="{Org_City}" name="{Org_City_Name}"></td>
</tr>
<tr class="Controls">
<th>State</th>
<td><input maxlength="250" size="50" value="{State}" name="{State_Name}"></td>
</tr>
<tr class="Controls">
<th>Zip</th>
<td><input maxlength="250" size="50" value="{Zip}" name="{Zip_Name}"></td>
</tr>
<tr class="Controls">
<th>Website</th>
<td><input maxlength="250" size="50" value="{Website}" name="{Website_Name}"></td>
</tr>
<tr class="Bottom">
<td align="right" colspan="2">
<!-- BEGIN Button Button_Insert --><input class="Button" type="submit" value="Add" name="{Button_Name}"><!-- END Button Button_Insert -->
<!-- BEGIN Button Button_Update --><input class="Button" type="submit" value="Submit" name="{Button_Name}"><!-- END Button Button_Update -->
<!-- BEGIN Button Button_Delete --><input class="Button" type="submit" value="Delete" name="{Button_Name}"><!-- END Button Button_Delete --></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<!-- END Record Sheet2 --><br>
</body>
</html>
|
 |
 |
kevind
Posts: 251
|
| Posted: 11/13/2007, 10:16 AM |
|
Hi,
(reply based on my knowledge of CCS 2.x)
Your project should have a data connection set for the MS Access database that is on your local drive. You'll find this under Project Settings / Connections. If you look at the Details of the Connection you should see 'Design' and 'Server' - right now, you probably have 'Server' set with 'same as design'.
what you need to do to get your project published is
1) determine where on your web site you want to publish the site
2) setup the FTP settings for CCS, allowing it to login and publish to the correct sub-folder
3) setup and DSN connection under the database settings of your hosted web site (you need to have sufficient Web Hosting package to be allowed this - most sites i've seen allow this. if using ODBC DSN - you can leave the 'same as design' set to yes under 'server' connection settings
3b) if you've used a connection string instead of ODBC DSN setup, you''ll need to check with your hosting service to determine the virtual path to the 'database' folder and create a connection string which includes that path - if you've used this, more than likely the 'server' path to the database is different than 'design' (your local station) and you'll need to set 'same as design' to NO and create another connection string.
4) upload the MS DB to the hosting web site database folder
5) publish the project (with destination set to FTP)
that's it for 2.x version - you may have to look around at the 3.x articles to determine settings for the items I mentioned.
hope it helps.
Kevin
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
spidey78
Posts: 9
|
| Posted: 11/13/2007, 6:19 PM |
|
Hey Kevind
Is there a way to put the database within the framework of my website. What I am trying to do is have the database within the framework of my website, not just set uploaded to the site. Is there a way to attach the file into my web framework?
thanks for the help
Sean
|
|
|
|
|
