Search found 176 matches

by admin12
Thu Jul 28, 2011 1:29 am
Forum: Databases
Topic: SOLVED - Displaying the fields from the DB
Replies: 17
Views: 11515

Re: Problems with 1 combobox - reading from database

Anyone? For some ODD reason, fldGender (a simple combobox with Male and Female in it) keeps causing me errors. This is the put statement that puts the choice in the variable Gender: put line (the menuhistory of btn "fldGender") of btn "fldGender" into Gender This does not work, it always returns "Ma...
by admin12
Thu Jul 28, 2011 1:27 am
Forum: Databases
Topic: SOLVED - How to create a new folder on server using FTP
Replies: 8
Views: 6302

Re: How to create a new folder on server using FTP

Mark, Thanks. get libURLftpCommand("MKD dirname",example.net:75,"root",field "password") OK, so if the path is ftp.travelandworkusa.com/public_html/userfiles,"username","password") That would be get libURLftpCommand("MKD dirname", ftp.travelandworkusa.com/public_html/userfiles,"username","password")...
by admin12
Wed Jul 27, 2011 9:56 pm
Forum: Databases
Topic: SOLVED - How can I make a variable useable from card to card
Replies: 8
Views: 6085

Re: How can I make a variable useable from card to card

Thank you.

I have it at the top of each and every script. It seems to be working well.

Mike
by admin12
Wed Jul 27, 2011 7:01 pm
Forum: Databases
Topic: SOLVED - How to create a new folder on server using FTP
Replies: 8
Views: 6302

SOLVED - How to create a new folder on server using FTP

I need to auto-create a file folder on a file server (already set up) based on the user's first and last name. I have already read through the ftp tutorial and got it working - but I need to create the folder first and then upload files to it. To add, I have the two fields set up - fldFirstName and ...
by admin12
Wed Jul 27, 2011 7:00 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SOLVED - how to create a folder on a server using ftp?
Replies: 4
Views: 3151

Re: how to create a folder on a server using ftp?

anyone?? I really need help with this to make the database work.

Thanks in advance.

Mike
by admin12
Wed Jul 27, 2011 6:48 pm
Forum: Databases
Topic: SOLVED - Displaying the fields from the DB
Replies: 17
Views: 11515

Re: When reading multiple fields from a database, use an array?

OK. I got it to work - except for one thing. Here is the code: set the itemDel to tab repeat for each line myLine in theData put item 1 of myLine into field "fldFirstName" put item 2 of myLine into field "fldMiddleName" put item 3 of myLine into field "fldSurName" put item 4 of myLine into field "fl...
by admin12
Wed Jul 27, 2011 6:26 pm
Forum: Databases
Topic: SOLVED - How can I make a variable useable from card to card
Replies: 8
Views: 6085

Re: How can I make a variable useable from card to card

Got it - I think it's working. I'll have to test it by making a bunch of records.

Mike
by admin12
Wed Jul 27, 2011 4:47 pm
Forum: Getting Started with LiveCode - Experienced Developers
Topic: SOLVED - how to create a folder on a server using ftp?
Replies: 4
Views: 3151

SOLVED - how to create a folder on a server using ftp?

I need to auto-create a file folder on a file server (already set up) based on the user's first and last name.

How would I do this?

I have already read through the ftp tutorial and got it working - but I need to create the folder first and then upload files to it.

How would I do this?

Mike
by admin12
Wed Jul 27, 2011 4:39 pm
Forum: Databases
Topic: SOLVED - Displaying the fields from the DB
Replies: 17
Views: 11515

Re: When reading multiple fields from a database, use an array?

Here is the entire opencard script with your suggestions (I have an invisible field called fldList that contains the all the fields separated by a return): ==================================== on opencard --Create a global variable for the db global dbID global curUserID global UN put numtochar(39) ...
by admin12
Wed Jul 27, 2011 4:01 pm
Forum: Databases
Topic: SOLVED - Displaying the fields from the DB
Replies: 17
Views: 11515

Re: When reading multiple fields from a database, use an array?

Well, Mike, I said you should make a field that contains the list, because we are assuming a return-delimited list. You can do it the way you showed in your previous post, but then you have to accommodate for the different delimiter by adjusting the script. Mark This is all very confusing for me. S...
by admin12
Wed Jul 27, 2011 3:46 pm
Forum: Databases
Topic: SOLVED - Displaying the fields from the DB
Replies: 17
Views: 11515

Re: When reading multiple fields from a database, use an array?

Mark,

I will read up on looping in Live Code.

Here is the fields:

put "FirstName,MiddleName,SurName,Gender,dobmonth,dobday,dobyear,DOB,EmailAddr,PrimTele,skype,ecn,promo_code" into myFieldList

Is that what you meant?

Mike
by admin12
Wed Jul 27, 2011 3:20 pm
Forum: Databases
Topic: SOLVED - Displaying the fields from the DB
Replies: 17
Views: 11515

Re: When reading multiple fields from a database, use an array?

Mike, There are a billion ways to do this. I've given you a few examples, which should be sufficient to get you started. If your list of fields and your data list are in the same order, you could use a counter. put 0 into myCounter set the itemDel to tab repeat for each line myFld in myFieldList ad...
by admin12
Wed Jul 27, 2011 2:42 pm
Forum: Databases
Topic: SOLVED - Displaying the fields from the DB
Replies: 17
Views: 11515

Re: When reading multiple fields from a database, use an array?

Mark,

The data is simply separated by spaces when I do an answer to theData. How would I put them in their requisite fields?

Fields being:

FirstName
MiddleName
SurName
Gender
DOB Month
DOB Day
DOB Year
Email
Phone
Skype
Emergency Number
Promo Code
created

Thanks for your help.

Mike
by admin12
Wed Jul 27, 2011 2:48 am
Forum: Databases
Topic: SOLVED - How to deconstruct a date?
Replies: 1
Views: 2385

SOLVED - How to deconstruct a date?

In the database, the three controls used to make the date of birth are separated out - they are drop down controls. My database only has one field dedicated to the DOB, so I added them together like so: put the text of field "MonthEntry" &space & the text of field "DayEntry" &comma & space & the tex...
by admin12
Wed Jul 27, 2011 2:45 am
Forum: Databases
Topic: SOLVED - Displaying the fields from the DB
Replies: 17
Views: 11515

SOLVED - Displaying the fields from the DB

I want to populate an existing form with the already existing data from the database. Here is the code I have already written: put "SELECT FirstName, MiddleName, SurName, Gender, DOB, EmailAddr, PrimTele, skype, ecn, promo_code FROM candidatecc where CandidateCCID = " &numtochar(39) &CurUserID &numt...

Go to advanced search