Genus | Algorithms & Data structures project | Learning library

Create Record type.

I am currently delving into parameterized queries with classic ASP and a MySQL database. I have an old page where visitors can search the database using a variety of hierarchical dropdowns that are populated from the database (e.g., Country, State, County). So the content of each dropdown will be filtered based on the selections made with the other dropdowns (7 total). I am trying to convert this page so that it uses parameterized queries.

In searching around the web, I think I have the steps necessary to create the queries correctly, but I am getting the following error.

Microsoft VBScript runtime error '800a01b6' Object doesn't support this property or method: 'Parameters.Append'

My code for the County dropdown is below.

I have the awk command below that is selecting rows in multiple files based on the given criteria. To identify which file the selected rows come from I want to include the filename as part of the rows that are been printed.

I am trying to display information taken from a mysql database but i do not want to display the 'id' field in the results. i got the displaying part down just fine. just need to remove a field from the view.

I have a large database filled with plant names. I have a column with the species (Latin) name, and one with the Dutch name. Unfortunately, the Dutch names are not complete.

Click here to view table

I think this is a simple task, but I'm a biologist who only knows a teeny bit of code and after several days of trying to figure this out, I'm at my wit's end :'(

Using terminal on a mac. I have a CSV file that I want to split into separate files by row (162 rows) and I want to name the file by the content of the first and second column (genus_species). Then I need all 162 genus_species to be saved as HTML files.

I have only attempted the "splitting" part with Ruby (recommendation from StackExchange/overflow). Below are some of my attempts. They are frankensteins of helpful-ish forums, and after each I made a little comment on why it did not work.

Example HTML

Something is wrong with the code in this class. I went over missing brackets and such but I can't find out the problem. The weird thing is, it runs fine locally, only when pushed onto the production server, it crashes (which makes it awkward to fix too).

It crashes on the very first line of the class declaration public ?string $header; It says 'syntax error, unexpected '?' (T_STRING), expecting function (T_FUNCTION) or const (T_CONST)'

I would like to analyse a list of orchids (input_df) if it contains orchid species that are on one of six lists. I import these lists from an xlsx file with six sheets as dictionary containing the six lists as DataFrames (orchid_checklists).

I´m struggling formulating a regular expression to extract all the species names (group1) and the author names (group2) from a list. I´m fairly new to python and would appreciate any help.

This is a part of the list:

Dalbergia acutifoliolata Mendonca & Sousa
Dalbergia adami Berhaut
Dalbergia afzeliana G.Don
Dalbergia agudeloi J.Linares & M. Sousa
Dalbergia albiflora Hutch. & Dalziel
Dalbergia altissima Baker f.
Dalbergia amazonica (Radlk.) Ducke
Dalbergia amerimmon L. ex B.D.Jacks
Dalbergia andapensis Bosser & R.Rabev.
Dalbergia arbutifolia Baker
Dalbergia arbutifolia aberrans Polhill
Dalbergia armata E.Mey.
Dalbergia assamica Benth.
Dalbergia aurea Bosser & R.Rabev.
Dalbergia baronii Baker
Dalbergia bathiei R.Vig.
Dalbergia benthamii
Dalbergia berteroi
Dalbergia pseudo-sissoo Miq.
Dalbergia ovata var. glomeriflora (Kurz) Thoth.
Dalbergia albiflora subsp. albiflora

Usually species names have a genus and a species name, and some have a subspecies name. I can catch those with: