879
社区成员
发帖
与我相关
我的任务
分享如何把二级目录插入数据库
<!---查询 --->
<cfinvoke component="CFC/admin" method="menu" returnvariable="menu"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link rel="stylesheet" type="text/css" href="../../css/hepu.css">
</head>
<body>
<h5>
<cfform action="addHandle.cfm">
<p> </p>
<table width="510" height="143" align="center">
<tr >
<td width="130" align="right">视频名称:</td>
<td>
<cfinput type="text" name="video" id="video" maxlength="100" required="yes" validateat="onsubmit" message="请输入视频名称" size="25" >
</td>
</tr>
<cfoutput query="menu">
<cfquery name="menu2" datasource="video">
select *
from dbo.menu
where fatherID=#menu.menuID#
</cfquery>
<tr>
<td width="130" align="right">#menu.menu# :</td>
<td width="368">
<cfif #menu2.recordcount# eq 0><!---id--->
<cfinput name="a" required="yes" id="#menu.menuID#" value="" message="请输入#menu.menuID#!" validateat="onsubmit" type="text" maxlength="100"/>
<cfinput type="hidden" name="menuid" value="#menu.menuid#" />
<cfelse>
<cfloop query="menu2">
<cfinput name="#menu.menu#" required="yes" id="#menu.menuID#" value="#menu2.menuID#" message="请输入#menu2.menuID#!" validateat="onsubmit" type="radio" maxlength="100" >
#menu2.menu#
</cfloop>
<cfinput type="hidden" name="menuid" value="#menu.menuid#" />
</cfif>
</td>
</tr>
</cfoutput>
<tr>
<td colspan="2">
<div align="center">
<cfinput type="submit" name="submit" value="提交">
</div>
</td>
</tr>
</table>
<p> </p>
<p> </p>
</cfform>
</h5>
</body>
</html>
<cfinvoke component="CFC/admin" method="menu" returnvariable="menu"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link rel="stylesheet" type="text/css" href="../../css/hepu.css">
</head>
<body>
<h5>
<cfform action="addHandle.cfm">
<p> </p>
<table width="510" height="143" align="center">
<tr >
<td width="130" align="right">视频名称:</td>
<td>
<cfinput type="text" name="video" id="video" maxlength="100" required="yes" validateat="onsubmit" message="请输入视频名称" size="25" >
</td>
</tr>
<cfoutput query="menu">
<cfquery name="menu2" datasource="video">
select *
from dbo.menu
where fatherID=#menu.menuID#
</cfquery>
<tr>
<td width="130" align="right">#menu.menu# :</td>
<td width="368">
<cfif #menu2.recordcount# eq 0><!---id--->
<cfinput name="a" required="yes" id="#menu.menuID#" value="" message="请输入#menu.menuID#!" validateat="onsubmit" type="text" maxlength="100"/>
<cfinput type="hidden" name="menuid" value="#menu.menuid#" />
<cfelse>
<cfloop query="menu2">
<cfinput name="#menu.menu#" required="yes" id="#menu.menuID#" value="#menu2.menuID#" message="请输入#menu2.menuID#!" validateat="onsubmit" type="radio" maxlength="100" >
#menu2.menu#
</cfloop>
<cfinput type="hidden" name="menuid" value="#menu.menuid#" />
</cfif>
</td>
</tr>
</cfoutput>
<tr>
<td colspan="2">
<div align="center">
<cfinput type="submit" name="submit" value="提交">
</div>
</td>
</tr>
</table>
<p> </p>
<p> </p>
</cfform>
</h5>
</body>
</html>
以上是我的代码，怎么把二级目录插入数据，求高手解答！
...全文
请发表友善的回复…
发表回复
Dogfish 2012-06-06
- 打赏
- 举报
这个要看设计了。其实就是设计一堆的input，提交的时候，可以根据input的名字来拿到正确的值而已。至于怎么insert，当然是cfquery啦（这是废话）。
Dogfish 2012-06-06
- 打赏
- 举报
排一下。好看些
<!---查询 --->
<cfinvoke component="CFC/admin" method="menu" returnvariable="menu"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link rel="stylesheet" type="text/css" href="../../css/hepu.css">
</head>
<body>
<h5>
<cfform action="addHandle.cfm">
<p> </p>
<table width="510" height="143" align="center">
<tr >
<td width="130" align="right">视频名称:</td>
<td>
<cfinput type="text" name="video" id="video" maxlength="100" required="yes" validateat="onsubmit" message="请输入视频名称" size="25" >
</td>
</tr>
<cfoutput query="menu">
<cfquery name="menu2" datasource="video">
select * from dbo.menu where fatherID=#menu.menuID#
</cfquery>
<tr>
<td width="130" align="right">#menu.menu# :</td>
<td width="368">
<cfif #menu2.recordcount# eq 0>
<!---id--->
<cfinput name="a" required="yes" id="#menu.menuID#" value="" message="请输入#menu.menuID#!" validateat="onsubmit" type="text" maxlength="100"/>
<cfinput type="hidden" name="menuid" value="#menu.menuid#" />
<cfelse>
<cfloop query="menu2">
<cfinput name="#menu.menu#" required="yes" id="#menu.menuID#" value="#menu2.menuID#" message="请输入#menu2.menuID#!" validateat="onsubmit" type="radio" maxlength="100" >
#menu2.menu#
</cfloop>
<cfinput type="hidden" name="menuid" value="#menu.menuid#" />
</cfif>
</td>
</tr>
</cfoutput>
<tr>
<td colspan="2">
<div align="center">
<cfinput type="submit" name="submit" value="提交">
</div>
</td>
</tr>
</table>
<p> </p> <p> </p>
</cfform>
</h5>
</body>
</html>
guest_007 2012-06-06
- 打赏
- 举报
<cfinvoke component="CFC/admin" method="menu"returnvariable="menu"/>
<cfset videoID=#createUUID()#>
<cfquery datasource="video">
insert into dbo.video (videoID,videoname)
values ('#videoID#','#Form.video#')
</cfquery>
<cfquery name="menu2" datasource="video">
select * from dbo.menu where fatherID=#menu.menuID#
</cfquery>
<cfset num=0>
<cfloop index="add" from="1" to="#menu.recordcount#" step="1">
<cfset num=num+1>
<cfset textID=#createUUID()#>
<cfif isdefined("a#num#") >
<cfset text="Form.a#num#">
<cfset text=Evaluate(text)>
<cfelse>
<cfset text="Form.as#num#">
</cfif>
<cfset menuID="Form.b#num#">
<cfset menuID=Evaluate(menuID)>
<cfquery datasource="video">
insert into dbo.text (textID,menuID,videoID,text)
values ('#textID#','#menuID#','#videoID#','#text#')
</cfquery>
</cfloop>
<cflocation url="add.cfm">
您看看 这个<cfset text="Form.as#num#">，我认为就是把这个改一改就好了
