OT: DHTML & Java
Hi there! I need some help on where to find some information about DHTML, it's kinda urgent if you don't mind ;) And does anyone knows where can I find a FREE applet that does text scrolling, and has an easy html output interface? I will explain better: somthing like it's a default, so i can understand and build a cfoutput code, to write the news: param name=news2"some estrage codes|ff|#news#"> Thanks everybody -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Easy way to get a random record
I've got an easier way - Run a query and populate a list - Generate a random number from 1 to query.recordcount - Then use ListGetAt(list, randomnumber) function to get the record with this code u don't need to have a sequential id field, but the list is sequential, so u don't have to worry if the number exists of not . :) []'s Vinicius -Mensagem original- De: Gary McNeel, Jr. <[EMAIL PROTECTED]> Para: Cf-Talk <[EMAIL PROTECTED]> Data: Quinta-feira, 15 de Junho de 2000 18:35 Assunto: Easy way to get a random record >Is there an easy way to pick a random record from a database. I have a >unique ID for each record, but it is not strictly sequential because of >record deletions. > >Here is my thought: > >1. Run a query and get the MAX and MIN IDs. >2. Do a loop using them as the beginning and ending range and generate a >random >number between them. >3. See if that number exists in the ID field of the db. >4. If yes, get the record, if not, try again. >5. Do this until you get a hit. >6. Alternatively I guess you could gen a random number and take the next >higher >number unless it is the highest number. > >That seems way to intensive and I know there must be a cleaner way. The >programmers must know a good way to do this. > >Any thoughts or SQL code would be greatly appreciated. > >Thanks. > >Gary McNeel, Jr. >Project Manager - DAC-Net, Research & Graduate Studies >Rice University - Houston >[W] 713-348-5184 >[M] 713-962-0885 >[H] 713-723-9240 > >"One good thing about apathy is you don't have to exert yourself to show >you're sincere about it." > >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: ASP
hi there! I know this is a CF list, but my boss asked me to create a template in ASP and I've never worked with it. I have a few easy questions: 1st. Where can I find a good tutorial on the net? 2nd. How do I return the "RecordCount" of a query? 3rd. How can I set the maxrows so I can create broken templates in a search (like next, and previous buttons, page1, 2, 3, 4) Thanks a lot Vinicius Carvalho Digicadd - Official Autodesk Reseller -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Encrypt problem
Hi there! I'm trying to encrypt the passwords of my users in an access database. As I don't need to cocern a lot with security issues, I'm using the #Encrypt()# function, but ... Here's a simple test: #pwd# #var# this code produces 2 diferents strings, the first one: (2U2@MEVV2ZX4 and the second one: (2U2@MEVV2ZZ, and whats most weird. If I press reload ... the second one becomes (2U2@MEVV2ZZ< So what can I do to encrypt my passwords? any other tag? Thanks Vinicius -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFTREE and JS
Hi there:
I have a JavaScript to access an Autodesk Plugin that looks like this:
function Layers_clientessta(Layer,VAL)
{
var Mapa = getMap();
var Clientes = Mapa.getMapLayer(Layer);
var T21710 = Mapa.getMapLayer(Layer);
if (VAL == 'ON')
{
if (Layer == 'CLIENTESSTA'){
Clientes.setVisibility(true);
Clientes.setRebuild(true);
}
if (Layer == 'T21710'){
T21710.setVisibility(true);
T21710.setRebuild(true);
}
}else
{
if (Layer == 'CLIENTESSTA'){
Clientes.setVisibility(false);
Clientes.setRebuild(false);
}
if (Layer == 'T21710'){
T21710.setVisibility(false);
T21710.setRebuild(false);
}
}
Mapa.refresh();
}
As you can see I pick up 2 parameters, the name of the layer and its
visibility
(on, off) so far so good ...
I was doing it using A Tag, like:
OFF
Once again, so far so good, then my boss asked me to use CFTREE, and I
tried:
Skipping the cfform and cftree, my item looks like this:
the problem is my href isn´t passing the atributes to my JS function.
Thanks
Vinicius Carvalho
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CFTREE and JS
Hi there:
I have a JavaScript to access an Autodesk Plugin that looks like this:
function Layers_clientessta(Layer,VAL)
{
var Mapa = getMap();
var Clientes = Mapa.getMapLayer(Layer);
var T21710 = Mapa.getMapLayer(Layer);
if (VAL == 'ON')
{
if (Layer == 'CLIENTESSTA'){
Clientes.setVisibility(true);
Clientes.setRebuild(true);
}
if (Layer == 'T21710'){
T21710.setVisibility(true);
T21710.setRebuild(true);
}
}else
{
if (Layer == 'CLIENTESSTA'){
Clientes.setVisibility(false);
Clientes.setRebuild(false);
}
if (Layer == 'T21710'){
T21710.setVisibility(false);
T21710.setRebuild(false);
}
}
Mapa.refresh();
}
As you can see I pick up 2 parameters, the name of the layer and its visibility
(on, off) so far so good ...
I was doing it using A Tag, like:
OFF
Once again, so far so good, then my boss asked me to use CFTREE, and I tried:
Skipping the cfform and cftree, my item looks like this:
the problem is my href isn´t passing the atributes to my JS function.
Thanks
Vinicius Carvalho
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
stats
Hi there! I'd like to create an application to generate stats of my site. First (to count the number of visits) I thought I could do something like this: In the application.cfm I increment a DB column everytime, but, within this I'll increment that number for every page request, I'd like to increment only once for user, how can I manipulate the session? would this work query updating the field ... Ok, but what if I'd like to create a counter for each page requested? Is there a way to discover what page the user is requesting? Thanks guys []'s Vinicius Carvalho -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
stats
Hi there! I'd like to create an application to generate stats of my site. First (to count the number of visits) I thought I could do something like this: In the application.cfm I increment a DB column everytime, but, within this I'll increment that number for every page request, I'd like to increment only once for user, how can I manipulate the session? would this work query updating the field ... Ok, but what if I'd like to create a counter for each page requested? Is there a way to discover what page the user is requesting? Thanks guys []'s Vinicius Carvalho -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
getting the name of the request page
This is a multi-part message in MIME format. --=_NextPart_000_0004_01BFC968.788DBD80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there! I'd like to know if there's a way to get the name of the page requested = by the user? I'm creating a stats system, which will get the name of the = template and for each request will increment a field in a database. Thanks Vinicius --=_NextPart_000_0004_01BFC968.788DBD80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there! I'd like to know if there's a way to = get the=20 name of the page requested by the user? I'm creating a stats system, = which will=20 get the name of the template and for each request will increment a field = in a=20 database. Thanks Vinicius --=_NextPart_000_0004_01BFC968.788DBD80-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
JS CFM & SQL
Hi there, I'm trying to write in a database, a value passed by a JS like: h = screen.height; Then I want to put it in SQL statement in a cfquery, how do I do it, I tried: INSERT Into table(height) VALUES(h) don't work. Then I tried: document.write(h); don't work either, what else can I do? thanks Vinicius -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
OT: Good ASP n' XML Reference
Does anyone has a good ASP and XML reference? Tutoruials, books and others. Thanks Vinicius -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
number of users Solution and a Problem
Well, I've seen an application totally buit in CF that shows in the login Screen how many users are conected to the system, so I thought it was possible. So, how do I increment that variable? I mean how do I know if a new session was started? If I can count the number of sessions, I thought in doing something like this: I create a Scheduled template that runs at every 2 minutes eg. , It checks how many sessions are actived and them set an application var to it. In my application.cfm I test this var, if its greater than a pre-defined number, I don't allow anymore users, if don't that's ok. The problem I found here is, as the template runs every 2 min. Let´s suppose it check at 14:00 and we had 4 users, suddenly at 14:01 2 users entered at the same time, and now I have 6 users (I want a maximum of 5) in the next check 14:02 the template sets my var to 6 and no one else gets in, BUT, there are 6 users one more than I would allow, what should I do now? Thanks Vinicius -Mensagem original- De: Dave Watts <[EMAIL PROTECTED]> Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Data: Quarta-feira, 3 de Maio de 2000 21:27 Assunto: RE: number of users >> How do I see how many users are conected to my page? After a user >> is authenticated via password using session variables, I need to >> know how many are conected so I can set a maximum number of >> simultaneous conections. And how will I know when a user leaves? > >You could count users by incrementing an application variable when they >start a session, but you can't really know when a user leaves - you can only >know when they've waited long enough between requests that their session has >timed out. You could use JavaScript to handle the event that occurs when >they leave a page, and have your JavaScript routine attempt to communicate >this back to the server, but that's about the extent of your control. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
number of users Solution and a Problem
Well, I've seen an application totally buit in CF that shows in the login Screen how many users are conected to the system, so I thought it was possible. So, how do I increment that variable? I mean how do I know if a new session was started? If I can count the number of sessions, I thought in doing something like this: I create a Scheduled template that runs at every 2 minutes eg. , It checks how many sessions are actived and them set an application var to it. In my application.cfm I test this var, if its greater than a pre-defined number, I don't allow anymore users, if don't that's ok. The problem I found here is, as the template runs every 2 min. Let´s suppose it check at 14:00 and we had 4 users, suddenly at 14:01 2 users entered at the same time, and now I have 6 users (I want a maximum of 5) in the next check 14:02 the template sets my var to 6 and no one else gets in, BUT, there are 6 users one more than I would allow, what should I do now? Thanks Vinicius -Mensagem original- De: Dave Watts <[EMAIL PROTECTED]> Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Data: Quarta-feira, 3 de Maio de 2000 21:27 Assunto: RE: number of users >> How do I see how many users are conected to my page? After a user >> is authenticated via password using session variables, I need to >> know how many are conected so I can set a maximum number of >> simultaneous conections. And how will I know when a user leaves? > >You could count users by incrementing an application variable when they >start a session, but you can't really know when a user leaves - you can only >know when they've waited long enough between requests that their session has >timed out. You could use JavaScript to handle the event that occurs when >they leave a page, and have your JavaScript routine attempt to communicate >this back to the server, but that's about the extent of your control. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444 > > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
number of users
This is a multi-part message in MIME format. --=_NextPart_000_000A_01BFA863.FC06DC80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How do I see how many users are conected to my page? After a user is = authenticated via password using session variables, I need to know how = many are conected so I can set a maximum number of simultaneous = conections. And how will I know when a user leaves? Thanks Vinicius --=_NextPart_000_000A_01BFA863.FC06DC80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable How do I see how many users are = conected to my=20 page? After a user is authenticated via password using session = variables, I need=20 to know how many are conected so I can set a maximum number of = simultaneous=20 conections. And how will I know when a user leaves? Thanks Vinicius --=_NextPart_000_000A_01BFA863.FC06DC80-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Application Security
This is a multi-part message in MIME format. --=_NextPart_000_0023_01BFA810.1DB1D500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there, I'm trying to build a password protec system using = application.cfm and session variables. I tried the "Guide to Cf logins" (or whatever) from cftutorials Its not = working, so I tried by my self : Application.cfm -- =09 =20 login.cfm -- Login Senha validate.cfm SELECT Login, pwd FROM Usuarios WHERE Login =3D '#Form.Login#' AND pwd =3D '#Form.pwd#' What=B4s happening here is that the system will never a user get in the = dir adm, even if he enters the correct login/pwd. Could someone help me please? If you don=B4t want to correct this = horrible code, please send me one that works THANKS A LOT GUYS Vinicius --=_NextPart_000_0023_01BFA810.1DB1D500 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there, I'm trying to build a password protec = system using=20 application.cfm and session variables. I tried the "Guide to Cf logins" (or = whatever) from=20 cftutorials Its not working, so I tried by my self : Application.cfm -- <CFAPPLICATION =20 NAME=3D"MyApplication" =20 SESSIONMANAGEMENT=3D"Yes" =20 SESSIONTIMEOUT=3D"#CreateTimeSpan(0,0,45,0)#" = =20 APPLICATIONTIMEOUT=3D"#CreateTimeSpan(0,0,45,0)#"> <cfset application.dsn =3D=20 "cadastro"> <CFPARAM = name=3D"session.LoggedIn"=20 DEFAULT=3D"FALSE"> <!-- If the user is not yet logged in, and = not=20 currently on the login = pages, or=20 the forgotten password page, --> <CFIF = #session.LoggedIn# IS=20 "FALSE"> <cfif Cgi.scripName IS NOT=20 "cadastro/adm/login.cfm" OR Cgi.ScriptName IS NOT=20 "cadastro/adm/validar.cfm">=20 <cflocation url=3D"../dcad2.html"=20 addtoken=3D"No"> =20 <cfelse> =20 </cfif> =20 <cfelse> </CFIF> login.cfm -- <form action=3D"validate.cfm"=20 method=3D"POST"><table><tr> <= ;td><font=20 class=3Dpadrao>Login</td> <td><input=20 type=3D"Text" name=3D"login"=20 size=3D"10"></td></tr><tr>&nbs= p;<td><font=20 class=3Dpadrao>Senha</td> <td><input=20 type=3D"Password" name=3D"pwd"=20 size=3D"10"></td></tr></table>= <input=20 type=3D"Submit" value=3D"Enviar"=20 class=3D"padrao"></form><cfset = session.loggedin =3D=20 false> validate.cfm <cfquery name=3D"checkuser"=20 datasource=3D"#application.dsn#" = dbtype=3D"ODBC"> =20 SELECT Login, pwd FROM Usuarios WHERE Login =3D=20 '#Form.Login#' AND pwd =3D=20 '#Form.pwd#' </cfquery> <cfif checkuser.recordcount GT = 0> <cfset=20 session.loggedin =3D true> <cflocation = url=3D"adm/adm.cfm"=20 addtoken=3D"No"><cfelse><cfset = session.loggedin =3D=20 false> <cflocation url=3D"login.cfm"=20 addtoken=3D"No"></cfif> What´s happening here is that the system will = never a=20 user get in the dir adm, even if he enters the correct = login/pwd. Could someone help me please? If you don´t = want to=20 correct this horrible code, please send me one that works THANKS A LOT GUYS Vinicius --=_NextPart_000_0023_01BFA810.1DB1D500-- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Very, Very weird problem
This is a multi-part message in MIME format. --=_NextPart_000_000F_01BFA45C.9AE1D0A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there! I'm having a very weird problem... I'm building a system where users can subscribe to some courses over the = net, my database looks like this: Students=20 - ID | Name | email | Phone Courses IDcourse | NameCourse SCourses (a table where I put the Student ID and tell which course is = hi/her doing) --- IDStudent | IDCourse My template looks like this SELECT DISTINCT IDStudent=20 FROM SCourses WHERE IDCourse IN (#ID#) Ok, I pass an Course ID to the template and it returns to me the name of = the students on it then I create a list SELECT Students.ID, Students.Name, Students.email, Courses.IDCourse, Courses.CourseName, SCourses.IDStudent, Scourses.IDcourse FROM Students, Courses, Scourses WHERE Students.ID IN (#list#) ANDScourses.IDStudent =3D Students.ID ANDScourses.IDCourse =3D Courses.IDCourse =20 When Generating a report it will looks like this ID Name Email Courses 10 MIKE [EMAIL PROTECTED]AutoCad 2000 Basic 21 Bruce [EMAIL PROTECTED] MapGuide Basic/3D Studio Basic And it goes. But if my list of ID gets bigger than 8 elements for my=20 surprise looks what happens: 13 Kate [EMAIL PROTECTED] AutoLisp 13 Kate [EMAIL PROTECTED] AutoLisp 13 Kate [EMAIL PROTECTED] AutoLisp 13 Kate [EMAIL PROTECTED] AutoLisp 13 Kate [EMAIL PROTECTED] AutoLisp 13 Kate [EMAIL PROTECTED] AutoLisp 13 Kate [EMAIL PROTECTED] AutoLisp 13 Kate [EMAIL PROTECTED] AutoLisp 13 Kate [EMAIL PROTECTED] AutoLisp 13 Kate [EMAIL PROTECTED] AutoLisp I tried to show my list just for debugging purpposes, and its ok the problem is in the query I belive, my list for the display=20 above looks like this list =3D 1,3,13,14,15,16,21,22,45,46 but only the user ID # 13 is shown. Any idea guys? Please I'll be in serious problems if I don't solve this. Thanks a LOT Vinicius Carvalho Digicadd Brazil Official AutoDesk Reseller --=_NextPart_000_000F_01BFA45C.9AE1D0A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi there!I'm having a very weird = problem...I'm building a system where users can subscribe to some = courses=20 over the net, my database looks like this: Students -ID | = Name | email=20 | Phone CoursesIDcourse = |=20 NameCourse SCourses (a table where I put the = Student ID and=20 tell which course is hi/her doing)---IDStudent |=20 IDCourse My template looks like = this <cfquery name=3DgetdistinctID=20 datasource=3D"#application.dsn#">SELECT DISTINCT = IDStudent=20 FROM SCoursesWHERE IDCourse IN = (#ID#)</cfquery> Ok, I pass an Course ID to the = template and it=20 returns to me the name of the students on it then I create a list<cfset=20 list=3D""><cfoutput = query=3DgetdistinctID> <cfset=20 list =3D ListAppend(list, = IDStudent)></cfoutput> <cfquery = name=3D"getstudents"=20 datasource=3D"#application.dsn#"> SELECT = Students.ID,=20 Students.Name, Students.email, Courses.IDCourse,=20 Courses.CourseName, SCourses.IDStudent,=20 Scourses.IDcourse FROM Students, Courses,=20 Scourses WHERE Students.ID IN=20 (#list#) AND Scourses.IDStudent =3D=20 Students.ID AND Scourses.IDCourse =3D=20 Courses.IDCourse </cfquery> When Generating a report it will = looks like=20 thisID Name =20 Email &n= bsp; =20 Courses 10 MIKE mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]&nbs= p; =20 AutoCad 2000 Basic21 Bruce mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] = MapGuide=20 Basic/3D Studio Basic And it goes. But if my list of ID = gets bigger=20 than 8 elements for my surprise looks what happens: 13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp13 Kate mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]= =20 AutoLisp I tried to show my list just for = debugging=20 purpposes, and its okthe problem is in
OT: Outlook express
This might sound stupid, but ... Can I create different profiles in Outlook express 4.0? I'm tired to share my mail box with my syster. []'s vinicius -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
DB Problem
Hi there! Im working on a project for my boss, it consists in a form where users can subscribe to some courses. Well my problem is ... In the main table I have a column that links to another (the course is a number that links to a table showing the names). Ok, My boss asked me to peform some verifications when the user try to subscribe (like if the user is already in the DB, we only add another type or course for him.) Well what happens now, my course column can't be a number anymore, cause I want to be a list 101,103,107 (and it goes for as manny courses as the user chooses) untill know ok. Problem is when creating a report page My SQL looks like these SELECT (fieldnames) FROM Main, Courses WHERE Main.Course = Course.CourseName Well It'll just don't work once my course column is a list. I tried IN operator but it didn't work either, what shoud I do? -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Pick Colors
Hi there! How do I use those "pick-color" system from windows in a form? To be more specific, I have a form where the user can select a color for a text, is there a way to open that lib from windows? Like in CFStudio or anyother program? And then set the value of the form to the chosen color in hexadecimal format. Thanks Vinicius -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Image Size
I guess I've already seen this question but... Is the a CF/CFX tag that tells me the size of an image sent by the user? This value must be returned to me in a way that I could check if the Width/height does not override my maximum setting. Thanks vinicius -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: Password protected directories
If you have gaps do the following: select ID from table Now grab a position Grab the article select article from someTable where ID = #ListGetAt(ID_List, position)# Using this you can have a list with following IDS 1,3,5,6 and garantee that all ID can be retreived. []'s Vinicius Carvalho -Mensagem original- De: Alexander Lamon <[EMAIL PROTECTED]> Para: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Data: Segunda-feira, 27 de Março de 2000 16:24 Assunto: RE: Password protected directories >Robert, > >Are the primary keys you refer to below consecutive *and* contiguous? If >so, you can do something like this: > > > > select article from someTable; > > > > > > > >select article from someTable >where ID = #randomID#; > > >*However*, if you have gaps in the numbers like 1,2,3,7, this won't work >for obvious reasons. > >Hope this helps, > >Alec Lamon >IT Manager >Wharton Direct > > >> Ok here is my problem, I have a database that has news articles. Now what >>my boss wants me to do is make it so the first feature story you see on the >>page is different each time you come on. It can be random and it can loop >>over once you have seen all the feature articles. The problem is the only >>unique field is the autonumber field so the feature articles could be >>15,18,34,48,78. How would I be able to make it so each article is different. >>Anyone have something they have already done that I could use or modify? >> >>Robert Everland III >>Network Administrator >>Orlando.com >> >>-- >> >>Archives: http://www.eGroups.com/list/cf-talk >>To Unsubscribe visit >>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >>send a message to [EMAIL PROTECTED] with 'unsubscribe' in >>the body. >--- --- >Archives: http://www.eGroups.com/list/cf-talk >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Cookie problem
I have a cookie called register and I put these values on it: Ok, then I retreive the data using ListGetAt(), but if the name contains 2 strings like Vinicius Carvalho, the Listgetat(cookie.register, 1) retreives only Vinicius and not Vinicius Carvalho. What's wrong? By the way, is this the only way to set a value to a cookie (lists)? []'s Vinicius Carvalho -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
